I am in the final stages of evaluating Couch Base as the preferred data store for financial markets data.
I have noticed if the query returns large amount of documents the executing time reported by the Couch Base UI increases a lot BUT may not be representative of how long the query took to run. For example this query
FROM DartAggregatedComplete t
WHERE t.ddasSnapshotVersion.asOfDate BETWEEN “2018-01-01T00:00:00” AND “2018-02-01T00:00:00”
Runs in 200 ms. My question is if the LIMIT is removed the User Interface reports after a while there is too much data to process.
I think the query has to run to completion before the LIMIT is applied.
Would this be correct?
- By placing the LIMIT, the query still runs to completion and extra time taken without the limit has got nothing to do with how long the query took to run BUT rather the time to buffer and display it on the client side.
- Rather silly question, but can I have a SELECT … FROM but display no data so I can get the actual query execution time.
I’m sorry for the rather trivial questions being asked, but I need to profile the query times to use Couch base as the preferred data store .