Sub Menu
Links Menu
Online Users

In total there are 306 users online :: 3 registered, 0 hidden and 303 guests

Most users ever online was 1091 on Wed Aug 16, 2023 5:27 pm

Registered users: Bing [Bot], Google [Bot], Majestic-12 [Bot] based on users active over the past 60 minutes

phpbb_search_wordmatch table large in size

Support for IntegraMOD 140

Moderator: Integra Moderator

phpbb_search_wordmatch table large in size

PostAuthor: binh.tang » Fri Feb 20, 2009 12:13 pm

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
User avatar
binh.tang
Members
Members
 
Posts: 43
Likes: 0 post
Liked in: 0 post
Joined: Tue Feb 06, 2007 12:11 pm
Cash on hand: 0.00

Return to IntegraMOD 140

Who is online

Registered users: Bing [Bot], Google [Bot], Majestic-12 [Bot]