[Koha-bugs] [Bug 15406] Very SLOW OAI server performance

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15406

Frédéric Demians <frederic at tamil.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Depends on|                            |15106
             Status|NEW                         |In Discussion

--- Comment #1 from Frédéric Demians <frederic at tamil.fr> ---
Bug 15106 contains the solution. Especially, an index must be added to
biblioitems/deletebiblioitems timestamp field:

KEY `timestamp_bibno` (`timestamp`, `biblionumber`)

You can confirm that this solution works for you by altering your DB schema:

ALTER TABLE biblioitems ADD KEY `timestamp_bibno` (`timestamp`,
`biblionumber`);
ALTER TABLE deletedbiblioitems ADD KEY `timestamp_bibno` (`timestamp`,
`biblionumber`)


Referenced Bugs:

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15106
[Bug 15106] Batch Patron Modification Performance Improvement
-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.