• Registered: 2004-12-01
  • Posts: 23

Topic: the size of the database.

Hello,

my forum has 31841 posts and 3279 topics so the size of the database is near 47mo because of the internal search engine(27mo). On my server, the size of each database is limited to 50mo. Friday, my forum was suspended by precaution and the search engine is now disable. So, i'm looking for another solution for the search engine. Is it possible to host the search engine table in another database ??

Thanks
David

armada's Website

  • From: France
  • Registered: 2004-11-06
  • Posts: 695

Re: the size of the database.

The logical solution would be to use the Fulltext search capability of MySQL, if you have it.

Jeu de rôle en ligne sur table virtuelle ⁂ Shadowrun France ⁂ Chez Blacky

Jérémie's Website

3 Reply by Tofi (edited by Tofi 2005-09-18 21:10)

  • Tofi
  • Junior Member
  • Offline
  • Registered: 2005-09-18
  • Posts: 2

Re: the size of the database.

armada wrote:

Hello,
the search engine is now disable

David

How did you do that ? I also have database size problems

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

Re: the size of the database.

Change the permissions of all the groups so that they can't use search, and truncate the search tables (oh, and then you'll have to edit the files so that the search table doesn't get filled in when people post).

5 Reply by Tofi (edited by Tofi 2005-09-18 21:19)

  • Tofi
  • Junior Member
  • Offline
  • Registered: 2005-09-18
  • Posts: 2

Re: the size of the database.

Thx, i was afraid to have to do so sad
Pity, i was about to install punbb on my website but the search tables are definitely too heavy (> 9 Mo for 4,9 Mo in posts table, 36 users, 1861 topics and 19297 msgs)