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

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?

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."

Re: The table "search_matches" is huge

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

This is an option too...