Forums intermittently going down?

[Vladimir Panteleev]

On Tuesday, 25 September 2018 at 21:12:54 UTC, Steven 
Schveighoffer wrote:
> I'll note that when I started running into DB slowdowns on a 
> system (not related to D), adding one index fixed the issue. 
> Sometimes linear searches are fast enough to hide in plain 
> sight :)

I'm no DBA. Here's the schema:

https://github.com/CyberShadow/DFeed/blob/master/schema.sql

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.