[WEB400] odbc performance change

[Kelly Cookson <kc62301@xxxxxxxxx>]

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