As a look into /var/lib/mysql/adele-slow.log shows, the AV_TEXT table is in the center of a lot of performance problems we're seeing here on antville.org. Looking for a fix I stumbled across PROCEDURE ANALYSE(), which is a very nice MySQL feature that tells you how database columns are currently utilized and what type definition MySQL would propose for those columns. The statement

SELECT * FROM AV_TEXT PROCEDURE ANALYSE(16,256)

produces a few interesting results:

I've tried them these out on my local installation and they seem to work fine, so I'm checking them into CVS and will eventually update the DB on antville.org

I am ready for donations or a "premium membership fee" in order to help antville improve. The more I use antville the more valuable antville becomes.

From time to time when i take a link to get to an antville log i get 'maximum count reach...'. After refreshing the load it works mostly. Before updating it didn´t happen. Is it a question of system ressources? And what about the hardware. How i remember (?) there is only a quite small Harddisk to work on. It should not be a such big prob to find a solution. I think, that a lot of antvillians would join helpin' to keep antville on work...