PLANNED MAINTENANCE

Hello, DataStax Community!

We want to make you aware of a few operational updates which will be carried out on the site. We are working hard to streamline the login process to integrate with other DataStax resources. As such, you will soon be prompted to update your password. Please note that your username will remain the same.

As we work to improve your user experience, please be aware that login to the DataStax Community will be unavailable for a few hours on:

  • Wednesday, July 15 16:00 PDT | 19:00 EDT | 20:00 BRT
  • Thursday, July 16 00:00 BST | 01:00 CEST | 04:30 IST | 07:00 CST | 09:00 AEST

For more info, check out the FAQ page. Thank you for being a valued member of our community.


question

gispyros_174198 avatar image
gispyros_174198 asked ·

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 characters needed characters left characters exceeded

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 characters needed characters left characters exceeded

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