Sorting result mysql query

  • eliot35

    (@eliot35)


    6 years ago

    Hey
    I’ve noticed that each time this query runs in mySQL my website is unresponsive (timeout error)

    View post on imgur.com

    That takes about 10 minutes… my db index is about 1,2 GB.

    Any idea why if I can fix it?

    Best Regards

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Mikko Saari

    (@msaari)

    How many posts you have in your database?

    Sounds like your site is just simply too big for Relevanssi and other self-hosted searches, and you need instead an externally hosted search like Elastic, Solr, Swiftype, LucidWorks Sitesearch, Algolia or AddSearch.

    Thread Starter eliot35

    (@eliot35)

    I’ve over 46k. I think I should have add more stopwords. I totally skipped that feature.

    Plugin Author Mikko Saari

    (@msaari)

    I would still suggest that you drop Relevanssi and use something more robust. This won’t be the end of your problems with Relevanssi with a database that big. Relevanssi is designed for the under 10k scale. You need something bigger.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Sorting result mysql query’ is closed to new replies.