3 ms·
> 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 SQLi
by mceachen 6y ago
> 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.