Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 29 Jun 2018, 18:46
Inna Inna is offline
 
Join Date: Jul 2016
Truncate searchcore_text and searchlog tables

Hello, some tables are large and I don't to truncate them or not.
searchcore_text is the main one, about two point five gigabytes.
I'm using Google search and i don't use forum built-in search.
Can i empty this table?
What about searchlog?
I've googled and figured out what are these tables used for, but as I'm using Google search, I believe there's no need to these tables.
Appreciations
Reply With Quote
  #2  
Old 03 Jul 2018, 16:50
Master Of Unive's Avatar
Master Of Unive Master Of Unive is offline
 
Join Date: Oct 2009
You can notice that searchcore_text is nearly same size as post table, they just construct these 2 in different way.

If you do not rely on built in search then yes, you can truncate those tables (searchcore, searchgroup, searchlog etc) and completely disable search feature in settings.

But if you ever back to the built in search you need to rebuild search index, it will take a very long time so you have to make sure.
__________________
Need something at bottom of the post.
Reply With Quote
  #3  
Old 04 Jul 2018, 18:38
Inna Inna is offline
 
Join Date: Jul 2016
Thanks for the reply.
I'll consider it.
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


New To Site? Need Help?

All times are GMT. The time now is 05:24.

Layout Options | Width: Wide Color: