Howdy,
While I've had a bit of experience with proprietary database systems, I'm quite new to ODBC with which I'm prototyping a replacement configuration database for my employer. The query performance of ODBC seems to leave a lot to be desired and a co-worker suggested MySQL as an alternative to Sybase Adaptive Server Anywhere (ASA). The current platform is Widows XP.
My main complaint with ODBC is binding results set columns; I've found that the SQLBindCol function takes about 100 ms, that means one second just to bind 10 columns!! Is this 'normal' ODBC performance? It's possible that I might get better performance by turning off logging, which I'll try Monday, but I doubt it.
I assume that the preferred C++ interface to MySQL is not built on top of ODBC, and thus has much better performance. Is this correct?
Many thanks!
Randy T. Merkel
[EMAIL PROTECTED]
http://webpages.charter.net/randy_merkel
NRA #52041050
ACLU #51754422
CRPA #262949
ICORE #CA 9730
ASSRA #7828
NMLRA #118275
<<...>>
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
