Anyone have any tips on speeding up entry searches? Ours are currently taking about 90 seconds per search.

Some stats about our Craft database:

  • Entries: 336,000
  • Relations: 4,390,000 (!!!)
  • Search Index Records: 320,000

It used to be fast. But the more data we get into it, the slower it goes. It's basically unusable now. We removed indexing on every field except for title, slug and item number. But that didn't help much.

1 Answer 1


Nothing to see here. We had a corrupt index.

Running this command in the DB brought our searches down from 90 seconds to 1 or 2 seconds. I'd still love it to be faster. But we can live with 2 seconds:

optimize table searchindex;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.