PDA

View Full Version : Searchindex

armagan
Fri 29th Mar '02, 10:38am
Hi There
My forum's db ıs almost 90 mb, and when I check the each ıtems, the largest item is searchindex whıch is 32 mb. What is this searchindex thing? and if empty this searchindex, will it be a problem with the forum?
Steve Machol
Fri 29th Mar '02, 12:38pm
If you empty the searchindex then the search finction will not longer work reliably on your forums.
Felix
Sun 31st Mar '02, 3:45pm
I got the same problem. After installing the attachments to files hack the db was 15 MB smaller. However, the searchindex is still over 10 MB in size.
Could you explain us, what it does and maybe bring up an solution to get the db smaller

regards
Felix
Steve Machol
Sun 31st Mar '02, 9:59pm
Originally posted by Felix
Could you explain us, what it does and maybe bring up an solution to get the db smaller
Explain what 'what' does? :confused:
Felix
Mon 1st Apr '02, 8:06am
what = the searchindex table........sorry about that :rolleyes:
Steve Machol
Mon 1st Apr '02, 1:07pm
The searchindex table is an index of all the searchable words on your forums. This is the key to the speediness of vB's search functions.
gazdet
Fri 5th Apr '02, 12:41am
Originally posted by armagan
Hi There
My forum's db ıs almost 90 mb, and when I check the each ıtems, the largest item is searchindex whıch is 32 mb. What is this searchindex thing? and if empty this searchindex, will it be a problem with the forum?

Check this thread. (http://www.vbulletin.com/forum/showthread.php?s=&threadid=39587&highlight=searchindex) ....it might be what ur looking for.