[lpiob]

If you\'re planning to use this implementation, or are already using it, consider following tips:


Tables don\'t have any indexes. It\'s a mistake. To (somewhat) fix it alter their structure, by executing this code:

Code:

ALTER TABLE accounts ADD PRIMARY KEY (Name);
ALTER TABLE bans ADD INDEX (Player), ADD INDEX (IP);

Although additional INTEGER column with PRIMARY KEY would be much, much faster.


Don\'t forget to periodically purge LOGS table, or it will turn into a performance hogging blackhole. Consider using ARCHIVE engine for performance boost.