Alex Rivera | Logout

Oracle connection compression?

Asked 2009-12-23T17:44:16.770
10

I have an application that uses JDBC to connect to Oracle 11g. Unfortunately, the machine my app is running on and the Oracle machine are connected via a somewhat low bandwidth connection. I haven't sniffed the connection, but I am pretty sure the data streaming across the connection is not compressed. For my application, I'm more concerned about bandwidth than latency.

Is there any way to tell the JDBC driver and Oracle to compress the data going through the connection? Google comes up with a lot of answers for data file compression, but I couldn't find anything about network protocol compression.

I'm using Oracle's thin driver, but if this is only supported by the OCI driver, I could switch to that. Thanks for any suggestions!

java oracle-database jdbc compression
Edit
Report

1 Answer

5

In my experience, high latency harms performance using the Oracle JDBC drivers far more than low bandwidth. (at least in the application I work on). You say you aren't worried about latency, but could you give an estimate on the latency of your low-bandwidth environment?

How big is the data you're sending? Are there BLOB columns? Are there other technologies involved, like a connection pool, or Hibernate? There are a lot of potential factors, not just if your data is being compressed.

Have you done any WAN emulation to try to isolate what is degrading your performance most? WANem is pretty easy to setup.

I've spent weeks on this problem, and 100-200ms latency hurt us much more than a 1Mbit bandwidth limitation. Hopefully you are in a different boat - compression an easier problem to solve.

answered 2009-12-23T18:13:04.797

Your Answer