diff options
| author | ivan <ivan> | 2009-04-23 04:57:06 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2009-04-23 04:57:06 +0000 |
| commit | 1da30e909e5792bfaf2181c2cd463e33411b2e65 (patch) | |
| tree | df57311a8cdd681ef7ee0ef66c874372c4897e2f | |
| parent | a6bad1f26c44c194d8d7a71c47ed97766e7759ce (diff) | |
we don't actually need the results ordered, and i'm sure it doesn't help the planner get us results sooner. last chance to try and get cursor approach working? RT#4412
| -rw-r--r-- | FS/FS/Cron/bill.pm | 4 |
1 files changed, 1 insertions, 3 deletions
diff --git a/FS/FS/Cron/bill.pm b/FS/FS/Cron/bill.pm index 64ef02003..f06fc1532 100644 --- a/FS/FS/Cron/bill.pm +++ b/FS/FS/Cron/bill.pm @@ -103,9 +103,7 @@ END $cursor_dbh->do( "DECLARE cron_bill_cursor CURSOR FOR ". - " SELECT custnum FROM cust_main ". - " WHERE ". join(' AND ', @search). - " ORDER BY custnum " #LIMIT 1000 " + " SELECT custnum FROM cust_main WHERE ". join(' AND ', @search) ) or die $cursor_dbh->errstr; while ( 1 ) { |