From: ivan <ivan>
Date: Thu, 23 Apr 2009 04:57:05 +0000 (+0000)
Subject: we don't actually need the results ordered, and i'm sure it doesn't help the planner... 
X-Git-Tag: root_of_svc_elec_features~1242
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=6fd4495cfb983901c1f7cb7ff15410048bda05d7

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
---

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 ) {