From 1da30e909e5792bfaf2181c2cd463e33411b2e65 Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 23 Apr 2009 04:57:06 +0000 Subject: [PATCH] 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 --- FS/FS/Cron/bill.pm | 4 +--- 1 file changed, 1 insertion(+), 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 ) { -- 2.11.0