Accounts cleanup needed?

[Callum]

Our accounts database (custom system using the SQLite functions) consists of around 100,000 accounts, with dozens of new accounts added daily. From researching PerformanceBrowser, it seems SQL queries are what is causing the longest execution time in scripts, therefore generating lag.

Would it be advised to prune all the old accounts (I'm sure 99% of the accounts are not currently in use) to optimize execution, or would it not really make that much of a difference?

[Benevolence]

I think you should purge the accounts, considering 99 percent are inactive.

[Zango]

Well if around 99% of the accounts aren't in use, perhaps move them to another database. Once they log in again, if they do, it will be moved to the new one, and moved back if they go inactive.

This would only cause lag on join (and only if an old user joins) since it has to look up in two databases, and an old inefficient one.

Does your SQLite databases have indices btw?