[CDO] Need help resolving query latency [message #1611782] |
Wed, 11 February 2015 11:07  |
Eclipse User |
|
|
|
Hello everybody,
we currently encounter some problems when executing queries from a client on a CDO server that is located in our local network. When executing arbitrary queries we experience latencies of approximatly 200ms, while executing the same queries on a server that is running on the same machine as the client only takes about 1-5ms. In both scenarios the database is located on the same machine as the server.
Does anyone of you have an idea where the packets might get stuck within the cdo/java stack and what can be done about it? Or are these query execution times considered normal when the packets go through the java tcp stack?
A few general information about our setup:
We are currently using CDO 4.3.0.v20140520-1823 and Java 1.8.0_31
Server and Client machines both run windows and firewalls are configured to allow communication on the cdo port.
To test general network latency we already performed a TCP latency test based on the powershell tool suite PSTools with 10000 iterations and a packet size of 50kB in our network and observed average roundtrip latencies of 5ms on packets send between the machines running the server and the client.
I have attached our cdo-server.xml and a minimal example which reproduces the latency in our setup.
Thank you in advance
Thomas Gerlitz
[Updated on: Wed, 11 February 2015 11:55] by Moderator
|
|
|
|
|
|
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.05389 seconds