3 ms·
It's great. Well done. 250ms is slow for a DB query though but for what you are doing and how you donit it is surprisingly fast.
by mememememememo 7mo ago
It's great. Well done. 250ms is slow for a DB query though but for what you are doing and how you donit it is surprisingly fast.
- russellthehippo 7mo agoThanks! yeah it's definitely slow, but compared to other options it's quite fast: - Neon startup is 500ms+ - a Fly Machine with a SQLite database on a volume takes 150ms+ to start up at minimum - restoring a db from S3 with Litestream can take multiple seconds depending on how long from the last snapshot and how large the database is - downloading a whole .sqlite file from S3 can be faster than Litestream restore but you still have to download the whole db file. - One similar option is, you could save each table in a separate database and only download the db files for tables you need for a given query, then ATTACH. But this is an awkward setup even though it's simple
- tuhgdetzhh 7mo ago[flagged]