[polyrand]

Don't forget that if you're using SQLite on something like EBS, multiple queries may not be efficient.

I'm saying this as a huge SQLite fan, but also beware of what kind of storage you're using in your instance.

[andersmurphy]

Yeah, you really want directly connected NVME drives to your machine/VPS. It can make orders of magnitude difference.