Truncate searchcore_text and postedithistory tables

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Saeed Fazlollahzadeh
    Member
    • Jul 2016
    • 72
    • 5.2.x

    Truncate searchcore_text and postedithistory 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
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 74132

    #2
    If you're not using the internal search, you can truncate the searchcore_text table.

    You will lost the history of post edits and the ability to restore posts if you delete the postedithistory table.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    • Saeed Fazlollahzadeh
      Member
      • Jul 2016
      • 72
      • 5.2.x

      #3
      Thanks Wayne, yeah I know about postedithistory. I forgot to edit and replace it to searchlog.
      What about searchlog table?
      What does it contain?
      It weighs not much, but I'm curious about it.

      Comment

      • Wayne Luke
        vBulletin Technical Support Lead
        • Aug 2000
        • 74132

        #4
        The searchlog holds temporary information on previous searches. This allows them to be shared among users. So if two users search for the same keywords, it can reuse a search instead of performing it twice. The entries should be deleted every hour. However as you're not using the internal search, it should be empty.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...