We are trying to improve the performance of pulling data from Exasol using ODBC drivers since it's slower than we expected. We have already improve the network capacity, but we would like to know if we could also increase the data fetch size somehow. We know that this should be possible using ODBC standard parameters like ArraySize.
Does anybody know what is the Exasol default value for fetching data (rows or bytes) and if it's possible to modify it on the ODBC configuration?
Thanks a lot
Thanks for your answer, I think those best practices are more oriented to code using the library on C/C++ or probably for ODBC developers. My question was more oriented to ODBC configuration paramenters and the default settings that come with the standard ODBC driver.
It would be something similar to the parameter fetchsize using the JDBC driver.
A bit of background, we are using BI Tool which connects to Exa using a ODBC driver and we would like to know how are the settings in terms of transferring data between Exasol and the BI tool using the ODBC
Hi @MiguelBer ,
while I do enjoy the vote of confidence from @exa-Chris I can´t say that I know the answer to either of your questions ( default value or how to set the fetch size ) - we tuned a bit in the realm of Informatica Powercenter when trying to optimize fetch sizes by enlarging DTM- ( process ) and Buffer Block Sizes so the application "probably" takes care of setting such odbc parameters "on the fly".
I do however have an Exasol Support Case open where I requested a complete list of ODBC-parameters ( no pressure there, @exa-Chris 😉 ), so once they put in an answer I´ll be glad to share it here.
I think I saw a similar conversation internally. Let me check and get someone to answer this. Unless @mwellbro knows this, as he knows everything 😁