Mysql usage problem
#1

Hi guys. I'm a small scripter with some problems, I hope there is a solution to my current problem.
We have over 125k players registered at our server, and eachtime someone joins, heavy lags occure for about 1-2 seconds. This is caused because the script is searching the user in the mysql playerlist. Our server gets joined every 10 seconds and the lag is epic!
If anyone knows an example, on how to reduce the selecting time without deleting the user, please help us out.
I really appreciate any help!

We already started to delete some inactive accounts, but this wont really fix our problem.

Thanks and regards

X
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)