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!