Posts: 447
Threads: 105
Joined: Feb 2013
Hello,
Im wondering , i v a server with +120 players everyday sometimes joining players every 2 seconds 2 players , which causing some lags, its like server cut respond for second sometimes , iv admin system and i think its take atime to load player stats ,but to fix that what should i do?
Posts: 637
Threads: 106
Joined: May 2011
Reputation:
0
If your using dini replace it with y_ini by ****** or make ir MYSQL.They're much faster.
Posts: 196
Threads: 71
Joined: Feb 2013
Reputation:
0
Are you logging things on your server to a single .log file? If yes, STOP doing that! That shit slows your server down while your logging is being processed. Rather save it to multiple files or use a data-base
Posts: 447
Threads: 105
Joined: Feb 2013
Posts: 447
Threads: 105
Joined: Feb 2013
What shall i do to make my admin system in mysql?
Posts: 72
Threads: 0
Joined: Jun 2013
Reputation:
0
There are plenty of examples on the SA:MP forum which teach and show you how to make one.
I suggest; to convert your users over, load them from the file if the MySQL user doesn't exist in the table, then save in MySQL once they disconnect. If it exists in MySQL then it wouldn't need to load from the file and if none exist and the user has never been on your server; insert into MySQL and save into MySQL. Eventually, your file system wouldn't be needed anymore and it can be descripted.
Best of luck,
Firewire.
