python-oracledb icon indicating copy to clipboard operation
python-oracledb copied to clipboard

Does/will oracledb support SQL*Net compression in thin mode?

Open HayDegha0917 opened this issue 1 year ago • 3 comments

We're accessing an Oracle DB over the WAN. Yes, this is not ideal but it's a business requirement. To improve the performance, we would like to turn on SQL*Net compression. Is this possible with thin mode? We don't want to use thick mode because we are running this in AWS Glue.

HayDegha0917 avatar Apr 15 '24 00:04 HayDegha0917

It is not currently supported. Is what you are requesting relevant to this post?

anthony-tuininga avatar Apr 17 '24 22:04 anthony-tuininga

@anthony-tuininga the motivation is the same. We want to use SQLNET.COMPRESSION. However, since we are not using the thick client, there has to be an equivalent parameter on the thin client.

Essentially, we want something equivalent to the Content-Encoding header of the HTTP protocol. I understand from the Oracle documentation that this is supported by the server as long SQLNET.COMPRESSION is set correctly on both the client and the server. When using the thick client (InstantClient), this is set in sqlnet.ora. When using the thin client, the client-side functionality has to be implemented in the Python code.

HayDegha0917 avatar Apr 23 '24 22:04 HayDegha0917

Noted.

The decision may be out of our hands, but we'll add the request to our list to review with the appropriate people.

cjbj avatar Apr 23 '24 23:04 cjbj