On two servers, which happen to be outside US, the java application is
extremely slow in loading images stored as BLOB. 15 minutes for a 10 mb
tiff, as compared to 20 seconds normally seen on the server in the States.
Both slow instances are on RAID 5. Execution plans and autotrace turn out as
fine as on the fast servers. I captured the running sql to be dbms_lob.read
that's taking the time. Even running the client app on the server box is
slow; ruling out the network as the culprit. The schemas are the same, as
well as the client code. Anyone ran into similar problem before?
Kenny
kyu_at_biodiscovery.com
Received on Thu May 08 2003 - 11:05:07 CDT
