| Summary: | Very SLOW OAI server performance | ||
|---|---|---|---|
| Product: | Koha | Reporter: | grharry <dhd.koha> |
| Component: | Web services | Assignee: | Bugs List <koha-bugs> |
| Status: | RESOLVED DUPLICATE | QA Contact: | Testopia <testopia> |
| Severity: | enhancement | ||
| Priority: | P5 - low | CC: | dhd.koha, f.demians, jonathan.druart, m.de.rooy, olli-antti.kivilahti, tomascohen |
| Version: | 3.20 | ||
| Hardware: | All | ||
| OS: | All | ||
| GIT URL: | Initiative type: | --- | |
| Sponsorship status: | --- | Comma delimited list of Sponsors: | |
| Crowdfunding goal: | 0 | Patch complexity: | --- |
| Documentation contact: | Documentation submission: | ||
| Text to go in the release notes: | Version(s) released in: | ||
| Circulation function: | |||
| Bug Depends on: | 15108 | ||
| Bug Blocks: | 15342 | ||
|
Description
grharry
2015-12-22 11:07:08 UTC
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`) (In reply to Frédéric Demians from comment #1) > Bug 15106 contains the solution. Must be a typo, bug 15106 is about batch patron modification. Frederic, Can you confirm that 15108 would actually resolve this one? (In reply to Marcel de Rooy from comment #4) > Frederic, > Can you confirm that 15108 would actually resolve this one? Yes. Even I haven't re-check recently. Then please go sign it off! |