question

gispyros_174198 avatar image
gispyros_174198 asked Erick Ramirez answered

ODBC Connection Issues

Hello!


I am testing the odbc driver inside sql server and I am facing the following problems


* The 1st call is taking a 15''-20'' to establish connections normally or sometimes even more. I have checked the odbc driver settings if i could handle that somehow else (increase connection pooling, or on sql server where I am testing it set connection time to 0 - unlimited) bit didn't make it better

* Run a simple select using on where statement the partition key but always seems to take the same time to run the query compared with select * from <table>.It seems that retrieves everything and filters that on sql server which is bad.

Could someone help me on the above issues?

Thank you in advance!

Spyros

odbclinked serverssql server
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered

@gispyros_174198 you haven't provided much information about your setup. Typically, the things we would look into are ODBC driver version, DSE version of your cluster, how you've configured the driver, etc.

With the limited information, it is difficult to say whether the problem is server-side (DSE cluster) or client-side. Ideally if you could provide a sample query so we have some context. Cheers!

Share
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.