Tinybird @tinybird.co · Feb 24 3/ When fetching paginated results from the database, you can use LIMIT and OFFSET to tell the db which "page" of data you want. Say, 100 rows for each page. If you ran the following query, it would go read the latest 100 rows, right? Probably not. Here's why...
0 likes 1 replies
?
Replies
4/ Most time series DBMSs have multi-threaded queries. Each thread fetches some data, and it all gets merged in the end. Here, each thread scans ~100 rows b/c it doesn't know what the other threads have. You scan more than you need, only to discard most of it. But there's a fix…