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.