A $10/month VM might only have a single thread anyway. Some providers like lightsail are really slow too.

echoangle 3 hours ago | parent | next [-]

You can run multiple OS threads (gunicorn workers) on one VM thread so the workers don’t have to wait for each others request to finish though, right?

And if you pay $10/month for a single threaded machine, you’re overpaying by a lot.

▲

jonatron 3 hours ago | parent [-]

True, but in this case with SQLite, there's unlikely to be much of a difference because there isn't the spare time available when waiting for a separate database server. I don't know what providers are good for a $10/month instance these days.

	▲	echoangle 2 hours ago \| parent \| next [-]
		How are you spending any non-negligible time reading from SQLite at 12 requests per second though? That would mean you’re spending something like 50 ms per request on reading from SQLite.
	▲	ErroneousBosh 2 hours ago \| parent \| prev [-]
		Most of the time you're hitting SQLite, you're just reading from it, and so it doesn't hold anything up.

▲

shakna 2 hours ago | parent | prev [-]

For a cheap VM, I'd still be expecting in the range of 500-1000 connections a second. Green threads are cheap, even with a single processor.

For a half-decent VM, I'd be expecting multi-thousand.

Single figures a second, is choked to a single connection at a time.