projects / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: cbcd722) | patch
Additional indexes on authority.full_rec. Thanks, EXPLAIN ANALYZE.
authordbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Thu, 26 Mar 2009 02:39:21 +0000 (02:39 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Thu, 26 Mar 2009 02:39:21 +0000 (02:39 +0000)
commit8aa15e104a2460ce2fa6ab070c87670c136df506
treee58704a5d575b28f92aa761257cb938bc7729ec3tree
parentcbcd722dbed7a04c69626b39ca22f2c170409b2bcommit | diff
Additional indexes on authority.full_rec. Thanks, EXPLAIN ANALYZE.
These reduced query times on a system with > 1 million authority records from 23000ms to 500ms. 'Nuff said!

git-svn-id: svn://svn.open-ils.org/ILS/trunk@12675 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/011.schema.authority.sql diff | blob | history
Evergreen ILS