PDA

View Full Version : do we need searchcore_text after installing sphinx


Dr.RakeshGarg
02 Aug 2010, 19:22
Hello,

I have successfully installed sphinx and converted all tables to InnoDB.
I have seen one table "searchcore_text" which is of about 1.5 GB!!

Do we need this table after using sphinx??


thanks

digitalpoint
06 Sep 2010, 19:52
I would leave the table, but you can empty the contents. You can truncate both the searchcore and searchcore_text tables if you are using a Sphinx-based search. The ONLY thing those tables are for is the default DB search.

Dr.RakeshGarg
07 Oct 2010, 03:44
okk thanks for your answer :)

final kaoss
11 Dec 2010, 17:12
Actually I've noticed that the searchcore_text, when emptied no longer displays users posts when you click on someones profile and then

Find all posts
Find all started threads Find all started threads

However, any posts made after the table is emptied will show up.

I would leave the table, but you can empty the contents. You can truncate both the searchcore and searchcore_text tables if you are using a Sphinx-based search. The ONLY thing those tables are for is the default DB search.