Bug #2797 Performance problems with Connector/ODBC
Submitted: 14 Feb 2004 12:02 Modified: 13 Sep 2007 17:45
Reporter: SINISA MILIVOJEVIC Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:3.51 OS:Any (any)
Assigned to: CPU Architecture:Any

[14 Feb 2004 12:02] SINISA MILIVOJEVIC 
Description:
Doing a volume of queries and subsequent fetches is about 15 times faster through
the native API that through the MyODBC driver. 

This is too slow..

How to repeat:
See above
[25 Feb 2004 12:16] Peter Harvey 
ODBC is an extra 2 layers of software (Driver Manager and Driver) with a high amount of functionality. At best, ODBC can perform about the same as the native C API but typically slower. For the most part, this is only noticable when several requests are batched together in some way.

Making the MyODBC driver perform faster will always be an objective. 

I will close this issue. If a specific performance problem arises from a customer complaint then we can create an issue (with test case demonstrating problem and perf. requirement).I can then check to see what can be done, if anything, to boost performance.
[13 Sep 2007 17:45] Jim Winstead 
Closing as 'Not a bug'. We need specific examples of performance  issues for them to be addressed.