greezybacon/osTicket-1.7 — pull request #2 by eivindgit (2013-11-22 16:43:11+00:00)
Title: Faster SQL-query

Faster SQL-query, huge performance improvement on installations with thousands of tickets. We use osTicket and have about 25 000 tickets. Increasing by 1000-1500 per month. Our employees were complaining about the speed of the system, so I decided to look into that. I think I found the sinner SQL-query, and rewrote it to be a lot faster.