Question - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Question (/showthread.php?tid=507253)

---

Question - SPA - 16.04.2014

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?

---

Re: Question - Dziugsas - 16.04.2014

If your using dini replace it with y_ini by ****** or make ir MYSQL.They're much faster.

---

Re: Question - Baltazar - 16.04.2014

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

---

Re: Question - SPA - 17.04.2014

Another idea?

---

Re: Question - BlackSirrah239 - 17.04.2014

MySQL is the fastest and probably safest databasing solution which is probably where the lag is coming from.

---

Re: Question - SPA - 17.04.2014

What shall i do to make my admin system in mysql?

---

Re: Question - Firewire - 17.04.2014

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.

---

Re: Question - Baltazar - 17.04.2014

SQLite is faster (unless your database is multi-terabyte). And you thought you can trick people that easy

---