]> git.evergreen-ils.org Git - working/Evergreen.git/commit
Enhance upgrade for complete subject indexing: drop the unnecessary final ORDER BY...
authordbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Tue, 13 Oct 2009 15:09:58 +0000 (15:09 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Tue, 13 Oct 2009 15:09:58 +0000 (15:09 +0000)
commit2786577189a2a3e838ea5a0830b7c16708bf7d0c
tree85e0e4b6b66bbe62fe04ef68c3e199d31115fd22
parent2c7c3c312ba70077e66691ee1281a343d653e724
Enhance upgrade for complete subject indexing: drop the unnecessary final ORDER BY clause and create an index on the source record.

Cuts upgrade time to about one one-hundredth of what it was before.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@14400 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/030.schema.metabib.sql
Open-ILS/src/sql/Pg/upgrade/0030.data.flat-subject-entries.sql