we don't actually need the results ordered, and i'm sure it doesn't help the planner...

diff --git a/FS/FS/Cron/bill.pm b/FS/FS/Cron/bill.pm
index 5101e0d..225b372 100644 (file)
--- 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 ) {