RE: odbc performance change -- WEB400

Kelly,

Not to ask a silly question, but are you sure the problem is on the PC?
That's a rather drastic change, I wonder if the initial query is taking
a long time on the iSeries for some reason (load, deleted access path,
additional records to review, etc.)

BTW, what size iSeries and PC? 1000 rows/second isn't all that
reasonable, IMHO. I just did a quick test in .NET of downloading my
latest QAEZDISK file (basically dspobjd *all/*all) which has 61,646
rows. I downloaded 88 bytes of data (select diobli, diobnm, diobtp,
diobat, diobtx) from each row and got the following speed:

Starting iSeries...
Rows: 61646
Elapsed: 4.98
Rows/Second: 12385.04

Starting ODBC...
Rows: 61646
Elapsed: 4.04
Rows/Second: 15273.86

Starting OleDb...
Rows: 61646
Elapsed: 5.43
Rows/Second: 11356.77

>From the iSeries .NET driver, the .NET ODBC driver (Client Access 5.2)
and the .NET OLE/DB driver (again, Client Access 5.2). So I'm getting 11
to 15 thousand rows per second, on a small 270 iSeries and my laptop
running XP. 

-Walden

------------
Walden H Leverich III
President & CEO
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
 
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Kelly Cookson
Sent: Friday, September 03, 2004 12:41
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.