search

oracle / python-oracledb

Python driver for Oracle Database conforming to the Python DB API 2.0 specification. This is the renamed, new major release of cx_Oracle
https://oracle.github.io/python-oracledb
Other
307 stars 59 forks source link

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

Open HayDegha0917 opened 2 months ago

HayDegha0917 commented 2 months ago

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.

anthony-tuininga commented 2 months ago

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

HayDegha0917 commented 2 months ago

@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.

cjbj commented 2 months ago

Noted.

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