diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2012-06-02 02:00:16 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2012-06-02 02:00:16 -0700 |
| commit | 4db356e2adbdab3817cb00d2ea761928161fd4f1 (patch) | |
| tree | b4a325ac83362cbda86a7a36523415b67224a8df | |
| parent | b41703512b80111e3b5ab00d4eb5ded8505cc041 (diff) | |
journal expensive parts parts of cust_main upgrade, RT#17629
| -rw-r--r-- | FS/FS/cust_main.pm | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/FS/FS/cust_main.pm b/FS/FS/cust_main.pm index 3022bfe8a..b382232b2 100644 --- a/FS/FS/cust_main.pm +++ b/FS/FS/cust_main.pm @@ -5044,6 +5044,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'; |