From: ivan <ivan>
Date: Thu, 2 Jun 2011 22:15:56 +0000 (+0000)
Subject: 200 records at a time, 16 kids and a two hour search timeout.  any improvement??
X-Git-Tag: freeside_2_3_0~190
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=e4f150238e6d07f2036e41d1c5066f3f1c51c960

200 records at a time, 16 kids and a two hour search timeout.  any improvement??
---

diff --git a/FS/bin/freeside-torrus-srvderive b/FS/bin/freeside-torrus-srvderive
index 19dd50ea4..765bd2270 100644
--- a/FS/bin/freeside-torrus-srvderive
+++ b/FS/bin/freeside-torrus-srvderive
@@ -11,8 +11,8 @@ use FS::Record qw( qsearch str2time_sql str2time_sql_closing concat_sql );
 use FS::torrus_srvderive;
 
 our $DEBUG = 2;
-our $max_kids = 12;
-our $search_timeout = 60*60; #30*60; # 15*60 5*60; #$torrus_srvderive->last_srv_date ? 5*60 : 15*60);
+our $max_kids = 16;
+our $search_timeout = 2*60*60; #60*60; #30*60; # 15*60 5*60; #$torrus_srvderive->last_srv_date ? 5*60 : 15*60);
 our %kids;
 
 my $user = shift or die &usage;
@@ -60,7 +60,7 @@ my $sql = "
 
 my $orderlimit = "
     ORDER BY srv_date, srv_time
-    LIMIT 100
+    LIMIT 200
 ";
 
 if ( driver_name =~ /mysql/i ) {