From a805e954792ea580d1c7f5cbd1b00f482676164d Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Sat, 2 Jun 2012 02:00:19 -0700 Subject: [PATCH] journal expensive parts parts of cust_main upgrade, RT#17629 --- FS/FS/cust_main.pm | 1 + 1 file changed, 1 insertion(+) diff --git a/FS/FS/cust_main.pm b/FS/FS/cust_main.pm index d7796d6c1..765e90eec 100644 --- a/FS/FS/cust_main.pm +++ b/FS/FS/cust_main.pm @@ -5061,6 +5061,7 @@ sub _upgrade_data { #class method 'UPDATE h_cust_main SET paycvv = NULL WHERE paycvv IS NOT NULL', ); + #this seems to be the only expensive one.. why does it take so long? unless ( FS::upgrade_journal->is_done('cust_main__signupdate') ) { push @statements, 'UPDATE cust_main SET signupdate = (SELECT signupdate FROM h_cust_main WHERE signupdate IS NOT NULL AND h_cust_main.custnum = cust_main.custnum ORDER BY historynum DESC LIMIT 1) WHERE signupdate IS NULL'; -- 2.20.1