projects / evergreen / equinox.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 10b2f6c) | 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:31:14 +0000 (03:31 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 24 Nov 2010 03:31:14 +0000 (03:31 +0000)
commite4c5617449cf817080f3f9872bb7d95845ae0174
treec5db92783211d1b86016377e727e82fda9fbe7e5tree
parent10b2f6c4f1fafc53c91c367b29c85f5fda6e1230commit | 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/trunk@18842 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)