PDA

View Full Version : Truncate searchcore_text and searchlog tables


Inna
06-29-2018, 04:46 PM
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

Master Of Unive
07-03-2018, 02:50 PM
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.

Inna
07-04-2018, 04:38 PM
Thanks for the reply.
I'll consider it.