[Kyosaur]

Quote:

Originally Posted by Bayler If you Store Chat Text to an SQL table, its going to pack VERY fast ... In a few days, that SQL database is going to be SOOO massive that your going to have issues, especially if your using Cron Tabs to do Auto SQL backups. I Strongly Suggest that you use File Based Logging for Chat Recording ... you can just as easily parse a file to a website as you can stream SQL to a website.

MySQL and massive loads go hand and hand lol. One of the server's i used to, lets say "manage", used the native sqlite and had pretty bad issues with such load, the second they switched over to MySQL every thing was peachy. They had over a million logs which wasn't including race statistics, objects/vehicles/hidden packages, nor anything player related. It ran smooth, and saw no problems with such a massive database.

Personally my server only has about 50000 logged events, and it too is doing just fine.

The worst thing you can do is use files for storing LARGE amounts of data, writing and reading from them can be a pain. Its a lot better to use a MySQL plugin or the native sqlite for logging large amounts of information.