Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
HayDegha0917 opened this issue Apr 15, 2024 · 3 comments
Open

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

HayDegha0917 opened this issue Apr 15, 2024 · 3 comments
Labels
enhancement New feature or request

Comments

@HayDegha0917
Copy link

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 HayDegha0917 added the enhancement New feature or request label Apr 15, 2024
@anthony-tuininga
Copy link
Member

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

@HayDegha0917
Copy link
Author

@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
Copy link
Member

cjbj commented Apr 23, 2024

Noted.

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

3 participants