We are working on a node.js application that is querying Dremio to populate some dashboards. We are seeing dramatic data transfer speed differences between CentOS and MacOs.
We are benchmarking against a query that returns about 57k records.
On our local MacOS based development machines, connecting to a Dremio cluster using the Mac ODBC connection is very fast. The query runs and receives the data in about 4 seconds. During the query node runs at 60% CPU for < 2 seconds.
On the production server running CentOS and using the Linux ODBC connection to connect to the same cluster, and the same query takes 2+ minutes. During these 2 minutes, node is running at 100% CPU.
We have ruled out network topologies and speeds as a factor.
Are there known performance issues with the Linux ODBC connector?
Are there settings to tune in the Linux ODBC connector that could improve its performance?
Thanks for the help,