1 Topic by chrizz (edited by chrizz 2006-06-29 10:46)

  • From: Eskilstuna, Sweden
  • Registered: 2004-05-23
  • Posts: 143

Topic: The table "search_matches" is huge

mysql> select count(*) from search_matches;
+----------+
| count(*) |
+----------+
|  2601088 |
+----------+
1 row in set (0.00 sec)

Is it really supposed to be like this? Rickard?

chrizz's Website

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: The table "search_matches" is huge

Yes. 2.6 million isn't that bad. The vBulletin forums we ran at Sweclockers.com pushed the equivalent table to 60 million rows.

However, it is my intention to add support for MySQL fulltext indexing in PunBB 1.3. With that enabled, you will be able to delete that table. With fulltext indexing, MySQL maintains those index tables internally.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • From: Leuven, Belgium
  • Registered: 2005-06-14
  • Posts: 2,653

Re: The table "search_matches" is huge

http://www.punres.org/viewtopic.php?id=1655

This is an option too...