https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42492 Bug ID: 42492 Summary: cleanup_database.pl's --sessdays option could be more efficient Initiative type: --- Sponsorship --- status: Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs@lists.koha-community.org Reporter: dcook@prosentient.com.au QA Contact: testopia@bugs.koha-community.org At the moment, the --sessdays option for cleanup_database.pl uses a 2 step approach. The first step is to retrieve ALL sessions, and then to run some regular expressions to extract "lasttime" or failing that "ATIME" or "CTIME". Then that time is checked against a 24 hour ago timestamp. We could actually handle that calculation in the SQL and let the database do the heavy lifting so tat we only have to run 1 query. Since it's a cronjob, it probably doesn't matter too much, especially if we use --sessdays regularly (see bug 42491). But... thought I'd highlight it anyway. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.