[reflekt]

I've accrued 8 million rows in a few months, and noticed that it's running very slow queries against the log with no indexes...

# User@Host: xxxx[xxxxx] @ localhost []
# Query_time: 14.945075  Lock_time: 0.000062 Rows_sent: 0  Rows_examined: 8553148
use xxxxxxx;
SET timestamp=1369595005;
UPDATE glowhostspamomatic_log SET `user_id` = "279880" WHERE `user_hash` = "1a63b3c7499deefee4b121c5672f883d";
# Time: 130526 15:09:39
# User@Host: xxxxxxx[xxxxxxxxxxx] @ localhost []
# Query_time: 15.324704  Lock_time: 0.000042 Rows_sent: 0  Rows_examined: 8553240
SET timestamp=1369595379;
UPDATE glowhostspamomatic_log SET `user_id` = "279881" WHERE `user_hash` = "acb81e895baacbef488a6a6ab07c8a7b";

This was version 1.2.4. I have just upgraded to 1.2.8 - is this issue fixed in the newer version? Should I be truncating my log every 24 hours? What is the log used for?

Thanks!