RE: [WEB400] odbc performance change

[Kelly Cookson <kc62301@xxxxxxxxx>]

I went to my Apache directives and found it set to
Timeout 300.  I assume I should have 300 seconds
before getting a time-out.

The error I'm getting appears to be from PHP. The
exact error message is:
 
Fatal error: Maximum execution time of 30 seconds
exceeded in
c:\apacheserver\Apache\htdocs\php\jobs\ISERIES2.PHP on
line 23

I went to my php.ini file and put 120 in the
following:

max_execution_time = 120     ; Maximum execution time
of each script, in seconds
max_input_time = 120    ; Maximum amount of time each
script may spend parsing request data

That allowed me to retrieve the 5000 records in 35
seconds. 

Kelly




--- "Flaker, Jeff" <JFlaker@xxxxxxx> wrote:

> Add 
> 
> TimeOut 120
> 
> (tweak this number) to your apache directives.....  
> 
> 
> 
> Jeffrey Flaker
> Senior Programmer/Analyst
> Linens 'N Things
> 6 Brighton Rd
> Clifton, NJ  07015
> Phone:   973-249-4384
> Fax:     973-249-4901
> http://www.lnt.com
> 
> -----Original Message-----
> From: web400-bounces@xxxxxxxxxxxx
> [mailto:web400-bounces@xxxxxxxxxxxx]
> On Behalf Of Kelly Cookson
> Sent: Friday, September 03, 2004 12:41 PM
> To: WEB400@xxxxxxxxxxxx
> Subject: [WEB400] odbc performance change
> 
> I'm running PHP scripts on Apache 1.3 on a W2K
> machine that get data
> from DB2/400 database files on an iSeries. The PHP
> scripts connect using
> odbc (Access for Windows driver). 
> 
> A few days ago, I ran the scripts and got reasonable
> performance (about
> 1000 records per second up to 500 records, with each
> record 80
> characters long). 
> 
> Today I ran the same scripts (no changes to scripts,
> server, or odbc
> settings) and I get 30 second time-out errors with
> only about 1000
> records downloaded successfully.
> 
> I look at my task manager and don't see anything
> eating up my W2K
> resources while the script is running (80% or higher
> system idle
> process).
> 
> Any ideas why the unexpected change in performance? 
> Any ideas how I can troubleshoot to find the
> problem?
> (I'm still new to all this.)
> 
> Thanks,
> Kelly
> 
> 
>       
>               
> __________________________________
> Do you Yahoo!?
> New and Improved Yahoo! Mail - 100MB free storage!
> http://promotions.yahoo.com/new_mail
> _______________________________________________
> This is the Web Enabling the AS400 / iSeries
> (WEB400) mailing list To
> post a message email: WEB400@xxxxxxxxxxxx To
> subscribe, unsubscribe, or
> change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/web400
> or email: WEB400-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives at
> http://archive.midrange.com/web400.
> 
> 
> 
> 
> _______________________________________________
> This is the Web Enabling the AS400 / iSeries
> (WEB400) mailing list
> To post a message email: WEB400@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/web400
> or email: WEB400-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/web400.
> 
> 



                
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail