On Tuesday, 25 September 2018 at 21:20:29 UTC, Vladimir Panteleev
wrote:
Sometimes the database (SQLite) behaves unusually slow until
you tell it to analyze itself, then it figures out some
internal index it has to use that it wasn't using before (with
no changes to schema). Those analysis runs take a long time to
run, though, during which the database is offline.
More generally, though, a big factor is probably that the size
of the data set is exceeding the intended use cases for the
database software used.
How much data can there possibly be for a mailing list? I
regularly see stories about companies using SQLite for databases
in the hundreds of GB.
