Hello,

Our database/server is choking whenever searching all tickets (open/closed/etc). I believe it's because we have too many closed tickets, and so each search takes too long.

Would it be possible to modify code somewhere so we can limit a search to 1 year or 6 months back rather than searching ALL tickets, open and closed?

7 days later

Hello, could add an additional attribute to which you already have, in class.ticket.php file found in the include folder, look at line 60 or so, or where get the variable $sql and end of the sentence add a date attribute, you selecione from the dates you want to the other.

I leave a link so you can see how to use the Between.

http://www.w3schools.com/sql/sql_between.asp(http://www.w3schools.com/sql/sql_between.asp)

Write a Reply...