projects / contrib / Conifer.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 5a7aaa6) | patch
Observed speed increases through judicious indexing
authorMike Rylander <mrylander@gmail.com>
Thu, 28 Feb 2013 18:28:20 +0000 (13:28 -0500)
committerBen Shum <bshum@biblio.org>
Thu, 14 Mar 2013 02:40:57 +0000 (22:40 -0400)
commite29bac21efa46736919f501d938c65149b3b0fd5
tree40d780ba9d214eafeedadc2e961e0cc60d67730dtree
parent5a7aaa6e832342b99eadca6c73ef7fc8c9d48867commit | diff
Observed speed increases through judicious indexing

These indexes drove high-cost queries down into the noise
at several sites.  They are more applicable for larger
installations, where "larger" can be defined as either "lots
of data in the db" or "has used Evergreen for a long time".

Signed-off-by: Mike Rylander <mrylander@gmail.com>
Signed-off-by: Ben Shum <bshum@biblio.org>
Open-ILS/src/sql/Pg/005.schema.actors.sql diff | blob | history
Open-ILS/src/sql/Pg/040.schema.asset.sql diff | blob | history
Open-ILS/src/sql/Pg/090.schema.action.sql diff | blob | history
Open-ILS/src/sql/Pg/200.schema.acq.sql diff | blob | history
Open-ILS/src/sql/Pg/400.schema.action_trigger.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.general-indexing-needs.sql [new file with mode: 0644] blob
Evergreen contribs