{"push_id":2798145979,"size":2,"distinct_size":2,"ref":"refs/heads/issue/large-dataset-performance","head":"7709346445dbb1bdf3223df625a043901a85a60d","before":"937a7a5ef7c5f807a5d03e794702b57e3df5dff9","commits":[{"sha":"263e0c9b426da1870e3ec9144100c55955b9a289","author":{"name":"Jared Hancock","email":"bc1a1a5435acd80888691d13507ed1bd0ac3f97d@gmail.com"},"message":"queues: cache queue counts\n\nIf APCu is available, then the queue counts can be cached between requests.\nThey are automatically cleared and recalculated if the status of a ticket\nchanges or if a queue or saved search is edited. Otherwise, the queue counts\nwill expire after an hour and be recalculated anyway.","distinct":true,"url":"https://api.github.com/repos/greezybacon/osTicket-1.8/commits/263e0c9b426da1870e3ec9144100c55955b9a289"},{"sha":"7709346445dbb1bdf3223df625a043901a85a60d","author":{"name":"Jared Hancock","email":"bc1a1a5435acd80888691d13507ed1bd0ac3f97d@gmail.com"},"message":"queues: Add \"rough\" counts\n\nThis changes the queue counts shown at the bottom of the page to no longer be\ncalculated using the SQL_CALC_FOUND_ROWS method of MySQL. Such is very slow for\nlarge recordsets. Instead, a rough count is computed based on the total number of\ntickets in the queue without respect for staff access. This is the fastest way to\nget a maximum number of possible tickets to be shown. The pagenation interface\nshould be changed to show only NEXT and PREVIOUS pages where the rough estimate can\nbe used to provide a rough idea of whether or not another page of data would be\navailable.\n\nFurthermore, if APCu is available, the rough count is stashed and kept between\nrequests so that the rough counts do not need to be re-tallied until they would\nchange from a ticket state change.\n\nAnother optimization might be to increment and decrement the queue rough counts when\ntickets are created or change states. In such a case, it could be identified which\nqueues the old ticket would have been (and decrement the count) and which queues the\nupdated ticket would be in (and increment the count).","distinct":true,"url":"https://api.github.com/repos/greezybacon/osTicket-1.8/commits/7709346445dbb1bdf3223df625a043901a85a60d"}]}
{"actor":{"display_login":"greezybacon"}}