Designer ODBC MySQL INSERT Performance

[cfgurney]

We utilize an Amazon RDS MySQL 8 instance for a variety of purposes, including as  repository for derived data and storing analytics. Historically, we've experienced poor INSERT or UPDATE performance with our workflows. The datasets in questions are generally less than 250,000 rows and INSERT elapsed time could be measured in minutes or hours. READ performance has not been a concern.

Recently, we looked at a variety of things that could be impacting this poor performance and among those were the ODBC driver itself. When we adopted Alteryx a few years ago, we used the freely available MySQL ODBC drivers (https://dev.mysql.com/downloads/connector/odbc/) and installed them on Windows 10 . We obtained and did some high-level testing with commercial drivers from CData and Devart. The results were fairly amazing: INSERTs that were taking 22 minutes with the free drivers are now taking 10-12 seconds.

I share this to see if other users have experience with these commercial drivers or if there was some sort of config that we missed with the community driver?