Server becoming too slow
nijel opened this issue · 6 comments
With more and more data coming in the server is becoming really slow. I believe it is mostly caused by missing indexes on fields which are often used for lookups.
We currently have around 50 k of incidents in the database, so I don't think this is some huge amount of data, it's rather that the queries are written poorly or not using indexes at all.
I have setup a similar server with 100,000 reports and incidents. The server is responding in less than 1 sec. Demo : http://collg.pe.hu/
PS : No extra index are created.
The server is responding very well right now(waiting TTFB : 5-6 sec).
Half an hour ago it was taking 2-3 minutes for responding(waiting TTFB : 2-3 mins).
So i suppose the issue was on server side rather than the scripts or queries.
Every page is responding well. Refer to the images below :
Maybe it has something to do with structure of the data as well - for example how are incidents grouped.
Seems like the server response is fluctuating. Right now, sometimes the request loads quickly and sometimes it's stalled.