From 6fd4495cfb983901c1f7cb7ff15410048bda05d7 Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 23 Apr 2009 04:57:05 +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 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 ) { -- 2.11.0