Data extraction with ODBC benchmarks

Hello Chaima,
We have not done any performance testing with the tools that you have listed. However, have a session will the customer will help our SME to understand the issue and trying to help them.
Thanks,
Jawahar.

Hi @Hibiki , from SAS logs, for example:
Before:
Total row fetch seconds were:                     104.270299
Total SQL execution seconds were:                   2.833655
After:
Total row fetch seconds were:                     574.147720
Total SQL execution seconds were:                   2.746438

The fetch time for this particular query went from 104seconds in February to 574 seconds in may, this applies to many of their queries that extract large amounts of data (for this example 9 columns, 30 million rows)

hi @chaima the data you posted has the answers to the Question you are looking for.
Total SQL execution time has not changed, the only change is the change in buffers transfer and write I/O's this is outside of vertica.
ask the customer to push the output to /dev/null and record the timings.
did you check what is the buffer size set?

Before:
Total row fetch seconds were: 104.270299
Total SQL execution seconds were: 2.833655
After:
Total row fetch seconds were: 574.147720
Total SQL execution seconds were: 2.746438