Details
-
Improvement
-
Resolution: Fixed
-
Trivial
-
None
-
Professional Edition
-
None
Description
This little change makes the delete query and also the count much faster as the mysql function has only to be called once and not for every row.
-$where = "UNIX_TIMESTAMP(`timestamp`) < $cutoff";
+ $where = "`timestamp` < FROM_UNIXTIME($cutoff)";
Attachments
Activity
| Status | Original: Resolved [ 5 ] | New: Closed [ 6 ] |
| Assignee | Original: Adam Armstrong [ adama ] | New: Mike Stupalov [ landy ] |
| Issue Type | Original: Add New Device / OS [ 10002 ] | New: Improvement [ 4 ] |
| Resolution | New: Fixed [ 1 ] | |
| Status | Original: Open [ 1 ] | New: Resolved [ 5 ] |