Topic: punbb db tables

can anyone plz tell me use of these tables in punbb database:

punbb_search_cache
punbb_search_matches
punbb_search_words

these 3 tables holds more than 1/3 of my total db usage. can I empty the database from time to time? will it cause any problem to system?

2

Re: punbb db tables

http://punbb.org/docs/dev.html#dbtables

3

Re: punbb db tables

you can empty these 3 tables, if you empty the database, you will lose everything

Re: punbb db tables

yemgi wrote:

you can empty these 3 tables, if you empty the database, you will lose everything

If you empty those 3 tables then searching will not work wink

Re: punbb db tables

sorry I meant emptying these 3 tables. I already truncated these 3 tree tables and everything seems to working fine.

6

Re: punbb db tables

These tables are used by the search system of the forum.
You can keep the tables smaller by excluding general words from the search engine.
Every word written in 'stopwords.txt' will be not be indexed.