too slow connection in 64kbps network

massi

Member
I have a big problem!!
In a 10mbps network it'all right, but when I prove my application on a 64kbps
network I wait five minutes for a simple query on an indexed table (queryall records=false)
and ther's a lot of router traffic.
How can I solve the problem? If I use sqlplus to execute query on an 64kbps network it's all right.
I explain thet I have table with 130.000 records.
Thanks

------------------
 
Direct Oracle Access should not be generating more network traffic than SQL*Plus. Perhaps you can set TOracleSession.SQLTrace to stTrue, run the application, and use the tkprof utility on the server to determine what exactly is going on.

------------------
Marco Kalter
Allround Automations
 
Back
Top