[FunnyBear]

Hey,

I recently started to rescript my server because of server lag. I updated from MySQL R5 to MySQL R33. Is there a way to reduce or avoid server lag completely, and make it run smoothly. The Login/Register/Admin system will be included within the gamemode, not as a filterscript. I don't want to continue without knowing if there is any way I can avoid lag in the future.

Thanks

[Misiur]

With change from R5 to R33 (R39 is the latest just FYI) did you change your all queries from unthreaded to threaded? If not, do it, otherwise you will still experience lag with every query.

[FunnyBear]

Quote:

Originally Posted by Misiur With change from R5 to R33 (R39 is the latest just FYI) did you change your all queries from unthreaded to threaded? If not, do it, otherwise you will still experience lag with every query.

Yep, I'm using threaded queries.

[FunnyBear]

Any other tips ?

[JhnzRep]

Avoid using the OnPlayerUpadte function, there are other better alternatives.

[FunnyBear]

Quote:

Originally Posted by JhnzRep Avoid using the OnPlayerUpadte function, there are other better alternatives.

Yeah, I use timers as an alternative to OnPlayerUpdate. Especially with my Anti-Cheat system.

Any other tips?

[JhnzRep]

Loop efficiency..For example using "foreach".

But you probably know that.

[DRIFT_HUNTER]

Benchmark your script (or just parts of it) to find out what causes lag and you will know what to do...

[Misiur]

Yeah, use this plugin, and find your bottlenecks.