From 242f01c9c4ffb27b206ab196ef73d648f451346b Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 1 Sep 2016 17:23:33 -0400 Subject: [PATCH] JBAS-1554 C/O history logging mods Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/patron-co-history-stage-1.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/KCLS/sql/schema/deploy/patron-co-history-stage-1.sql b/KCLS/sql/schema/deploy/patron-co-history-stage-1.sql index 24286497ad..45609cefa9 100644 --- a/KCLS/sql/schema/deploy/patron-co-history-stage-1.sql +++ b/KCLS/sql/schema/deploy/patron-co-history-stage-1.sql @@ -164,8 +164,8 @@ BEGIN ); -- useful for alleviating administrator anxiety. - IF circ_counter % 5000 = 0 THEN - RAISE NOTICE 'Migrated history for % total circs', circ_counter; + IF circ_counter % 10000 = 0 THEN + RAISE NOTICE 'Migrated history for % circs', circ_counter; END IF; circ_counter := circ_counter + 1; @@ -173,8 +173,8 @@ BEGIN END LOOP; -- useful for alleviating administrator anxiety. - IF usr_counter % 1000 = 0 THEN - RAISE NOTICE 'Migrated history for % total users', usr_counter; + IF usr_counter % 500 = 0 THEN + RAISE NOTICE 'Migrated history for % users', usr_counter; END IF; usr_counter := usr_counter + 1; -- 2.11.0