[yanir3]

Quote:

Originally Posted by Vince What is the server's resource usage when the game starts to lag? Also mind giving the output of (run it in a client like phpMyAdmin): PHP код: EXPLAIN SELECT `username` FROM `newrp_users` WHERE `username` = 'RandomName' AND `status` = 4  Put an index on username if you haven't done so already.

I have never used indexes on MySQL, mind explaining their purpose and contribution to the code?
Note that, I select by username only once, after that I use ID to save data.

Here's the output though.