MySQL Forums
Forum List  »  Connector/ODBC

Re: ODBC parallel query performance issue using C++
Posted by: Bogdan Degtyariov
Date: May 04, 2020 04:03AM

There is no limit for the number of threads in ODBC. You can run as many as you like.

It is possible that the bottle neck for the performance is somewhere else. It could be the network bandwidth if the server is running remotely. It could be the MySQL server performance, which depends on many factors. For instance, if each thread inserts large amounts of data in the database the performance can degrade because of disk I/O on the server host or less than optimal configuration of the server.

Depending on the client code the ODBC system can also be a subject to slowing down with many concurrent threads. For instance: the ENVIRONMENT handle for ODBC registers and unregisters new connections. Each such operation is protected by a mutex, which after some number of concurrent requests can cause delays for other threads and make them wait until the operation is completed. This is just one example of how it might happen.

My point is that when something like that happens it is a good idea to try using profiling tools to see where exactly the main delays occur.

Options: ReplyQuote


Subject
Written By
Posted
Re: ODBC parallel query performance issue using C++
May 04, 2020 04:03AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.