• rajuru
  • PunBB senior member
  • Offline
  • Registered: 2007-02-20
  • Posts: 187

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?

linux wallpapers
swords and sandals 2

rajuru's Website

2 Reply by MattF

  • MattF
  • Senior Member
  • Offline
  • From: South Yorkshire, England
  • Registered: 2007-03-15
  • Posts: 1,956

Re: punbb db tables

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

MattF's Website

3 Reply by yemgi

  • yemgi
  • Senior Member
  • Offline
  • From: Crawley, West Sussex
  • Registered: 2007-04-10
  • Posts: 254

Re: punbb db tables

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

Powered by FluxBB

yemgi's Website

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

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

  • rajuru
  • PunBB senior member
  • Offline
  • Registered: 2007-02-20
  • Posts: 187

Re: punbb db tables

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

linux wallpapers
swords and sandals 2

rajuru's Website

6 Reply by K-Ray

  • Registered: 2006-08-24
  • Posts: 12

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.