Server Lag - 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: Server Lag (/showthread.php?tid=527868)

---

Server Lag - Sledgehammer - 24.07.2014

Our community are currently experiencing some difficulties currently with a lag problem. I don't know where ever this is new, but when-ever the a player seems to login every has a lag spike for a second or two. Unfortunately I doubt it would be the OnPlayerConnect function causing this (Even after using another versions OnPlayerConnect, it does exactly the same thing)

Our server runs on all the latest includes and plugins that SA-MP has to offer.. Our service also runs of MySql so our development team think that may be causing the issue or the host so I doubt either.

Any suggestions upon we can change to make the performance run better in the script to avoid lag? (When I mean lag, I mean every has a spike icon above their ID etc witch is very annoying especially when your going to kill someone then it just happens to lag. ))

---

Re: Server Lag - Hanger - 25.07.2014

I experienced such problem only when I used remote location mysql server - not localhost. It probably is when player logins so I would make sure everything is cached properly and no errors are present via mysql_debug.

---

Re: Server Lag - SickAttack - 25.07.2014

It's a problem with your MySQL code. Check it and fix known issues, and try to optimize it at its best.

---

Re: Server Lag - Sledgehammer - 25.07.2014

The debug gives no errors when a player logs in so I'm not to sure where the problem is. I'll post some of the query's if I have two.

---

Re: Server Lag - Astralis - 25.07.2014

Use profiler plugin, and then you will see what's using so much CPU.

---

Re: Server Lag - Sledgehammer - 25.07.2014

Thanks for the suggestion! I'll try it out now.

---