Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 02 Aug 2010, 18:22
Dr.RakeshGarg Dr.RakeshGarg is offline
 
Join Date: May 2009
do we need searchcore_text after installing sphinx

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
Reply With Quote
Comments
  #2  
Old 06 Sep 2010, 18:52
digitalpoint's Avatar
digitalpoint digitalpoint is offline
 
Join Date: Mar 2004
Real name: Shawn
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.
Reply With Quote
  #3  
Old 07 Oct 2010, 02:44
Dr.RakeshGarg Dr.RakeshGarg is offline
 
Join Date: May 2009
okk thanks for your answer
Reply With Quote
  #4  
Old 11 Dec 2010, 16:12
final kaoss final kaoss is offline
 
Join Date: Apr 2006
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.

Originally Posted by digitalpoint View Post
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.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 23:14.

Layout Options | Width: Wide Color: