[CDO] Need help resolving query latency [message #1611782] |
Wed, 11 February 2015 16:07 |
Thomas Gerlitz Messages: 9 Registered: November 2013 |
Junior Member |
|
|
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 16:55] Report message to a moderator
|
|
|
|
Re: [CDO] Need help resolving query latency [message #1611825 is a reply to message #1611802] |
Wed, 11 February 2015 16:37 |
Thomas Gerlitz Messages: 9 Registered: November 2013 |
Junior Member |
|
|
Hello Esteban,
thank you for your reply. It seams that I have not described my setup correctly:
We are currently using hsqldb that is started directly by the cdo server. Latencies (>200ms) can be observed when I use two machines in our setup. One running the cdo client application and one running the cdo server and the database.
When we move all these components (client,server and db) on the same machine we do not observe the described latencies.
I have now corrected this in my first post.
I hope these clarifications help to understand my problem.
Best Regards
[Updated on: Wed, 11 February 2015 16:55] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03806 seconds