WordPress.org

Forums

Relevanssi - A Better Search
[resolved] size of wp_relevanssi table (3 posts)

  1. mp459
    Member
    Posted 1 year ago #

    Hey everyone

    Indexing and some other operations on my installation take a long time. I think part of the reason is that the wp_relevanssi table has over 1 million records. THe "state of the index" shows about 4k documents indexed:

    Documents in the index: 4043
    Terms in the index: 1101952
    Highest post ID indexed: 27730

    Does this seem normal?

    mickey

    https://wordpress.org/plugins/relevanssi/

  2. Mikko Saari
    Member
    Plugin Author

    Posted 1 year ago #

    Yes, that is normal. It's just 270 terms per post, not that much for a site with longer articles.

    Indexing the whole thing is slow, but fortunately you don't have to do that often – it's a good idea to reindex the whole database sometimes, maybe once a year. If search is too slow, try setting a limit on searches or reducing the limit setting.

    If it's still too slow, then Relevanssi is not the correct tool for you.

  3. mp459
    Member
    Posted 1 year ago #

    Thanks, Mikko. The search itself is working well. It's only some db operations that take up to 2 minutes. Working on offloading the db to an AWS RDS instance.
    Y

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Relevanssi - A Better Search
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic

Tags

No tags yet.