RE: odbc performance change

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.