projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 589690a) | patch
Speed up 'archive stat cats' database upgrade user/dbs/speedier_0663_upgrade
authorDan Scott <dan@coffeecode.net>
Sat, 7 Jan 2012 21:31:38 +0000 (16:31 -0500)
committerDan Scott <dan@coffeecode.net>
Sat, 7 Jan 2012 21:31:38 +0000 (16:31 -0500)
commitc282ff50c31edbf6fcf02c1aa467473ad2691c7c
tree65d1a6678e5cb5f9a057dab0ff318c897090afdbtree
parent589690affc8b0bc4c3464d77a6a55439f945cb72commit | diff
Speed up 'archive stat cats' database upgrade

The action.circulation table has four triggers that fire on UPDATE
events, and the 0663 database upgrade issues two updates that affect
every row in that table - which can take a long time to complete on
systems with relatively active circulation systems. We can speed things
up somewhat by preventing the triggers from firing during the update.

Signed-off-by: Dan Scott <dan@coffeecode.net>
Open-ILS/src/sql/Pg/upgrade/0663.schema.archive_circ_stat_cats.sql diff | blob | history
Evergreen ILS