Description
I have 30 documents, each ~180k.
If I try to fetch more than ~5 such documents via the Documents tab, (10 is the default in chrome) chrome hangs.
I can retrieve ALL 30 documents from the Query tab in around ~50ms with no problem whatsoever, using this simple query:
SELECT dev.* FROM dev WHERE type='form' |
Only the Documents tab fails.
I wonder if this has something to do with the query that the Documents tab generates on my behalf:
`select meta().id from `dev`.`_default`.`_default` data where type='form' order by meta().id limit 10 offset 0` |
I'm not using a 'scope' or a 'collection'. Nor do I want to.
These documents aren't very big. I have 18GB of memory assigned to the bucket with only 118MB in use. I'm retrieving documents where type='form'. I have a GSI on 'type'.
Furthermore, because the console automatically caches the current search in the 'documents' tab, as soon as I've accidentally performed a query that will melt chrome (e.g. fetching 10 or more of said documents), the console caches the result and I can no longer EVER open the console to the documents tab again, because it will re-crash, then re-crash, then re-crash. The ONLY way I can recover is to manually clear chrome browsing data.
At the very least, I would expect couchbase to attempt to detect a previous hang and clear the current document search that caused it, so that you have some hope of returning to the console again.