
November 3rd, 2004, 11:08 AM
|
|
Professional Slacker
|
|
Join Date: Jun 2001
Location: Houston
Posts: 20
Time spent in forums: 5 h 50 m 33 sec
Reputation Power: 0
|
|
Improving connection speed to DB2 on AS400
Basically, my problem is trying to improve the speed of an existing connection between our Windows server and our AS400 DB2. Even the simplest query takes about 15 seconds to make the round trip.
I rely on Client Access Express to handle my ODBC requests from my PHP code. But there has got to be a better way to do this. I have seen some commercial PHP applications connected to AS400s that had queries that were lightening fast.
Is there something besides Client Access Express that I can use to improve my query time?
Its an AS400 V5R1m0 with DB2 (not sure of the version yet).
|