]> git.evergreen-ils.org Git - Evergreen.git/commit
Add a unique index on biblio.record_entry.id
authordbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Tue, 7 Apr 2009 13:44:40 +0000 (13:44 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Tue, 7 Apr 2009 13:44:40 +0000 (13:44 +0000)
commit52e00a59fa5f627c13c92fdd100335335b920682
tree4dbbd82dc91fcd49a854768b7a15150e5924cb0e
parente99858671db19e07e61224757ff9f8bc14706c8c
Add a unique index on biblio.record_entry.id
On a large system (2M records), this reduced ingest time from 45-60 seconds / record to 5 seconds / record

git-svn-id: svn://svn.open-ils.org/ILS/trunk@12811 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/010.schema.biblio.sql