03.02.2019, 06:11
MySQL is faster than SQLite but that all also depends on your database and how you manage it.
I run a query every month that deletes accounts inactive for 2 months and remove accounts of hackers and just keep the ban records because I ban their IP and account-name.
In some tasks such as the top list etc, I cache them every hour from the database and have a command to force update it where necessary.
I run a query every month that deletes accounts inactive for 2 months and remove accounts of hackers and just keep the ban records because I ban their IP and account-name.
In some tasks such as the top list etc, I cache them every hour from the database and have a command to force update it where necessary.