Re:Cross-Database Queries in SQLite
by mceachen on Sunday February 21, 2021 @11:11PM
(#26220761)
> I don’t know if the sort of performance issues I was seeing was tied to SQLite or not though
It's certainly doable to serve million-asset libraries with SQLite (PhotoStructure is proof of this).
You need to be careful with indexed queries and make sure you've set up a large enough RAM cache, but for PhotoStructure, almost all queries are kept under 10-50ms.
It's certainly doable to serve million-asset libraries with SQLite (PhotoStructure is proof of this).
You need to be careful with indexed queries and make sure you've set up a large enough RAM cache, but for PhotoStructure, almost all queries are kept under 10-50ms.