Function-based bibs-by-item-age enhancement
authorLiam Whalen <whalen.ld@gmail.com>
Mon, 28 Oct 2013 06:45:19 +0000 (23:45 -0700)
committerLiam Whalen <whalen.ld@gmail.com>
Mon, 28 Oct 2013 06:46:16 +0000 (23:46 -0700)
commit69f83682e0f2c0e716485c7c2ade03b105d90200
tree8b8c101247e0eb755a1b76f20194142d470b558a
parent917ef3f0b4fe6fa5ce2de96f40aade1830c85525
Function-based bibs-by-item-age enhancement

I added a slight tweak.  When looping over the libs to find if they
have any newer records, if the result set already has enough records in
it to statisfy the offset and limit, then the SQL only looks for
records that are newer than the oldest record in the result set
currenlty being built..

Signed-off-by: Liam Whalen <whalen.ld@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