Connection parameters need to be filled in before the script can be run. The intent is for this to be a simple enough script to provide iterations on running a SELECT query solely for testing data transfer and memory usage rates for simple queries.
The initial sample here is designed for testing against Snowflake, and so contains functions for testing the ADBC Snowflake driver, the snowflake-python-connector, and using ODBC via pyodbc.
If matplotlib is installed, it will also draw the timing and memory usage up as charts which can be saved.
The file odbc/main.cc contains code to utilize an ODBC driver and the BindCol interface in order to perform a simple query and retrieve data. This was used for benchmarking against Snowflake to compare with the ADBC Snowflake driver.
It can be built by simply using cmake as long as you have unixODBC or another ODBC library that can be found by cmake for building. After building the mainprog, it can be run with a single argument being the ODBC DSN to use such as “DSN=snowflake;UID=;PWD=;”.