https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37487 Bug ID: 37487 Summary: import_records missing index on upload_timestamp field Change sponsored?: --- 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 cleanup_database.pl deletes import_records and import_batches based on import_records.upload_timestamp, but this isn't an indexed field. That means the database needs to do a row scan through all rows in order to find which rows to delete. This is inefficient, so it's slow when you have a large number of rows. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.