do we need searchcore_text after installing sphinx

[Dr.RakeshGarg]

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]

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]

okk thanks for your answer :)

[final kaoss]

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.