18.12.2010, 16:38
Asking about speed for mysql has as much to do with the mysql server and the table layout as the mysql plugin. I notice you update off of username, do you have atleast an index, if not a primary key on your Username column? Also shouldn't you have an "If (PlayerConnected(i))" so you don't save people who are offline?
For weapon saving with a short historical data I have a table with a couple million rows, and can do changes to it in less then 20 ms most of the time, even when what I am doing could be affecting 480 rows at once, so yes it can be quite fast.
For weapon saving with a short historical data I have a table with a couple million rows, and can do changes to it in less then 20 ms most of the time, even when what I am doing could be affecting 480 rows at once, so yes it can be quite fast.