I'm kind of at the end of my rope about a performance problem that renders my website useless, so I would really appreciate some help.
I'm running Django 1.9, django-haystack 1.6, Elasticsearch 1.7, on Ubuntu Server 16.04 LTS.
I have 3 indexes:
- Users, about 20,000 entries
- Gear, about 50,000 entries
- Images, about 200,000 entries
If I index Users and Gear, everything is fine.
As soon as I index a few hundred Images, the whole website comes down to a crawl (pages needing minutes to open) even on pages that are not making any Haystack queries.
If I delete all Images from Elasticsearch, the website returns to being snappy instantly.
Say I was waiting for a page to load, and 10 seconds in I just delete all Images from Elasticsearch, suddenly my page will load before my eyes.
I have no idea how to debug this, can somebody offer some advice?