http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15406
Bug ID: 15406
Summary: Very SLOW OAI server performance
Change sponsored?: ---
Product: Koha
Version: 3.20
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Web services
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
I noticed a very slow performance on oai server koha version 3.22 !
In particular the query
(
SELECT biblioitems.biblionumber, biblioitems.timestamp, marcxml
FROM biblioitems JOIN oai_sets_biblios ON biblioitems.biblionumber =
oai_sets_biblios.biblionumber
WHERE timestamp >= '1970-01-01 00:00:00' AND timestamp <= '2015-12-22 23:59:59'
AND oai_sets_biblios.set_id = '4'
)
UNION
(
SELECT deletedbiblio.biblionumber, null as marcxml, timestamp
FROM deletedbiblio JOIN oai_sets_biblios ON deletedbiblio.biblionumber =
oai_sets_biblios.biblionumber
WHERE DATE(timestamp) >= '1970-01-01T00:00:00Z' AND DATE(timestamp) <=
'2015-12-22T23:59:59Z' AND oai_sets_biblios.set_id = '4'
)
ORDER BY biblionumber LIMIT 51 OFFSET 0
As constructed by oai.pl
Requires about a minute to get results for each fetch!
So according to my rough calculations
a 500K marcs catalogue would require about 6 days to be harvested!
Harry!
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
