Jump to content

Huge full text index file [solved]


Kiwi Chris
 Share

Recommended Posts

I have a site with about 16K pages, with most of these (15K + ) being templates with just two text fields (including page title), along with several page reference fields, and a couple of numeric fields  and all the tables take up just over 20MB of storage, however there is a huge full text index file of over 2.1GB that seems to be totally out of proportion to the size of the database.

Does anyone know whether this is normal behaviour with Processwire?

From the reading I've done, it seems a full text index of similar size to the table it indexes is not unexpected, but 100x the size of all the tables in the database seems excessive.

If this isn't normal, what's the best way to fix this? 

Edit: It turns out the huge index was related to logging of imports to a text field by this module:

I'll post in that thread regarding the issue since it's module related.

  • Like 1
  • Thanks 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...