vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Truncate searchcore_text and searchlog tables (https://vborg.vbsupport.ru/showthread.php?t=326520)

Inna 06-29-2018 04:46 PM

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

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.


All times are GMT. The time now is 06:54 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05480 seconds
  • Memory Usage 1,703KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete