...actually I've never seen in in 1.9.3.So, my system is an upgrade from 1.6. I upgraded it 1.6->1.7->1.8->1.9. Besides the fact that I lost some tickets, I did not see any issues, until i wanted to see the closed tickets (84k+).... The page was waiting and waiting, other users were not able to do anything and the mysql was clogged with a query like: SELECT count(DISTINCT ticket.ticket_id) FROM ost_ticket ticket LEFT JOIN ost_user user ON user.id = ticket.user_id LEFT JOIN ost_user_email email ON user.id = email.user_id LEFT JOIN ost_department dept ON ticket.dept_id=dept.dept_id WHERE ( ( ticket.staff_id=1 AND ticket.status="open") OR ticket.dept_id IN (1,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21) ) AND ticket.status='closed';I killed some of the queries after 20 minutes, running.... I even ran that in cli, still working and working and no result after minutes and minutes waiting.What's going on? My system is unusable due to this unexpected behavior...Thanks!