Page 1 of 1

phpbb_search_wordmatch table large in size

PostPosted: Fri Feb 20, 2009 12:13 pm
Author: binh.tang
Hi everyone,

I noticed that the "phpbb_search_wordmatch" table is huge!
I just checked and it has over 7 million rows and size was over 200MB! That's more than half of the total size of my database.

I always empty it out every few months otherwise it just snowballs up to a huge size. I don't know what that table is, I'm assuming it indexing all the words in the forum posts or something? After deleting

Does anyone know what this table does and whether it can be emptied automatically?
Why does it even grow to that size anyway?

Thanks,
Binh