PDA

View Full Version : the "word" table


Skee
Mon 6th Aug '01, 5:49pm
What is the purpose of the "word" table in the vB db? Can i safely delete it and keep vB working w/o problems (disabling some features of course)? How?

JenniferS
Mon 6th Aug '01, 7:40pm
your search would break. who knows what else.

Skee
Thu 9th Aug '01, 4:21pm
anything ELSE? cos i'm willing to disable searches!

JenniferS
Thu 9th Aug '01, 6:27pm
and mind you this could have disastrous consequences

empty your word table, don't delete it. then disable searches.

Mark Hensler
Thu 9th Aug '01, 7:30pm
Why are you so intent on getting rid of that table?

Chris Schreiber
Thu 9th Aug '01, 7:58pm
As others have stated, you should remove the word table itself or you will have to modify alot of the vBulletin code. If you don't need and use the search feature, and you want to save disk space, then you can disable the search feature through the control panel, then run these queries to empty the search, searchindex and word tables:

DELETE FROM search;
DELETE FROM searchindex;
DELETE FROM word;

Skee
Fri 10th Aug '01, 3:48pm
Thank you thank you thank you!!
My boss says he'll kiss your feet if you ever meet, you saved him the price of paying more for hosting!! :) Saved more than 2 megs of DB space!

Mark Hensler
Fri 10th Aug '01, 8:35pm
2 megabytes? This whole thing was to save 2 megabytes?
You'll make that up easy after a while of usage... unless you start pruning old posts.