diff options
| author | ivan <ivan> | 2009-04-23 04:57:05 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2009-04-23 04:57:05 +0000 |
| commit | 6fd4495cfb983901c1f7cb7ff15410048bda05d7 (patch) | |
| tree | 70e10c8764648d33fe0c4438c35d83928250547f | |
| parent | 9f9bf2008844e95b0d93c73626ea134b7f97a2f8 (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 5101e0dad..225b372f2 100644 --- a/FS/FS/Cron/bill.pm +++ b/FS/FS/Cron/bill.pm @@ -107,9 +107,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 ) { |