We have now had the system in production for about a year and a month. As the system has grown. Some screens now load slowly. I believe this is due to the amount of tickets, about 105,000 incidents, it is trying to load per query.
The slowest screen to load is the "Add Parent" and "Add Child" screens. These use the same query it is the "Default Incident Query".
What can be done to hep speed this up?.
I have questioned altering this query to add the filter of not closed, but this query if used by so many different screens it can not be altered...