Function-based bibs-by-item-age enhancement
authorMike Rylander <mrylander@gmail.com>
Tue, 8 Oct 2013 17:45:37 +0000 (13:45 -0400)
committerMike Rylander <mrylander@gmail.com>
Wed, 9 Oct 2013 00:47:59 +0000 (20:47 -0400)
commit3e5c85f097b404caa29c50ac2378e434ee87bd4e
treed16aa0b215d7cf3d96d46898449bad06ea94308e
parentb8ec73d3f50e2c1b87ed8f112feab645fa69fd10
Function-based bibs-by-item-age enhancement

From Hubert Lubaczewski (a.k.a. depesz), based on investigation of
performance issues at the database layer of Evergreen, we received
an initial implementation of a replacement bibs-by-item-age mechanism.
See http://markmail.org/thread/3pe3uzokzzcqwy5b for details, but the
tl;dr version is a speedup on test data from ~13s to about 3ms.

The version offered removed some functionality, which I have attempted
to reimplement within his framework. See http://markmail.org/thread/3pe3uzokzzcqwy5b#query:+page:1+mid:bekujg5ggfydujdl+state:results
for the details of that.

Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/src/perlmods/lib/OpenILS/Application/SuperCat.pm
Open-ILS/src/sql/Pg/999.functions.global.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.function.bibs_by_item_age.sql [new file with mode: 0644]