5 ms·
If you’re pushing down the data, you’re losing the real-time capability no? If you want fast, adhoc, real-time querying, load the data as it’s created directly
by hipadev23 3y ago
If you’re pushing down the data, you’re losing the real-time capability no?
If you want fast, adhoc, real-time querying, load the data as it’s created directly into duckdb or clickhouse. Now you’ll have sub-100ms responses for most of your queries.
- alextheparrot 3y agoI'd assume they mean users interacting with the chart vs first load. So the user sees the base chart (Let's say 1MB of data on the server, less depending what gets pushed to the user) and then additional filters, aggregations, etc. are pretty cheap because the server has a local copy to query against
- izyda 3y agoYes -- sorry, I meant exactly the above.