From: Ivan Kohler Date: Sat, 2 Jun 2012 07:39:05 +0000 (-0700) Subject: time parts of cust_main upgrade, RT#17629 X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=aa1210004d3249eb1c9616f748b97f2ce91de9ae time parts of cust_main upgrade, RT#17629 --- diff --git a/FS/FS/cust_main.pm b/FS/FS/cust_main.pm index d4ddacc23..d18ec1cc7 100644 --- a/FS/FS/cust_main.pm +++ b/FS/FS/cust_main.pm @@ -5057,9 +5057,12 @@ sub _upgrade_data { #class method #DCRD to be safe "UPDATE cust_main SET payby = 'DCRD' WHERE payby = 'BILL' and length(payinfo) = 16 and payinfo ". regexp_sql. q( '^[0-9]*$' ); + my $t = time; foreach my $sql ( @statements ) { my $sth = dbh->prepare($sql) or die dbh->errstr; $sth->execute or die $sth->errstr; + warn (time - $t). " seconds\n"; + $t = time; } local($ignore_expired_card) = 1;