3 ms·
Even if you "skip the API" you still have to think about access patterns for the data, otherwise client-side query performance is going to be abysmal. You would
by Hakkin 3y ago
Even if you "skip the API" you still have to think about access patterns for the data, otherwise client-side query performance is going to be abysmal. You would basically have to define your "API" via what indexes you create on the data.
- abdullin 3y agoWith a local SQLite database you don’t need to pay cost of network transfers. A dozen of local SQL calls could be way faster than a single API call within a region.
- Hakkin 3y agoThat's true, but low query latency doesn't mean much if you have to do a full table scan for your query. Some thought still needs to be put into how the clients will query the data, so it's really not as simple as just "ship your entire database to the client and let them figure it out".