projects / evergreen / equinox.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: f374767) | patch
Add an index on asset.copy(create_date) for item-age browse
authordbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 24 Nov 2010 03:32:44 +0000 (03:32 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 24 Nov 2010 03:32:44 +0000 (03:32 +0000)
commitcd8ba53d268ea4464fcba22b4e736cde3d3653e1
tree8b09fe6f97fff98483a9814c4dc7285946acd740tree
parentf37476749ffc1d902de3d64bc5eddc138039c9b8commit | diff
Add an index on asset.copy(create_date) for item-age browse

Running an item-age browse against a database with a reasonable
number of entries in asset.copy is dog-slow without an index
like this.

git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_2_0@18843 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/002.schema.config.sql diff | blob | history
Open-ILS/src/sql/Pg/040.schema.asset.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/0466.schema.asset-copy-add-create-date-index.sql [new file with mode: 0644] blob
Evergreen working repo (Equinox)