Tinybird @tinybird.co · Feb 20 4. Index/sort by time When you retrieve logs, you usually want them for a certain time period. Indexing/sorting by time (and using columnar storage) makes retrieval much faster. Bonus: Sort first by client_id if you only want to retrieve logs for one client at a time.
0 likes 1 replies
?
Replies
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.