Tinybird @tinybird.co · Feb 20 5. Pre-aggregate Use rollups to pre-compute aggregates. Then during retrieval, first fetch your pre-computed aggregates and merge them with results from a raw table query to capture the edge cases.
0 likes 1 replies
?
Replies
6. Use pagination and map pre-aggregates to limits Pagination minimizes the amount of data the app must pass over network, but in multi-threaded queries, it can still be inefficient. Use your pre-calculated aggregates to map time ranges to limits.