Quote:
|
When you kill something and get the faction hit or when you add that aa point or loot some plat it all wrties to the database
|
From mysql.com
Quote:
OPTIMIZE TABLE works the following way:
If the table has deleted or split rows, repair the table.
If the index pages are not sorted, sort them.
If the statistics are not up to date (and the repair couldn't be done by sorting the index), update them.
|
If you are adding/deleting rows or changing indexed fields then this might have some value, but I think the cases you quote are changing non-indexed fields in the DB, so optimize table wouldn't have much effect. Having said this, I am no mysql expert, so I may be wrong.