Hi.
On Fri, Feb 09, 2001 at 11:49:23AM -0500, [EMAIL PROTECTED] wrote:
> Hello,
>
> In an earlier post I complained of performance problems with ODBC+MySQL
> when running a server which makes many 'small' queries and writes. What is
> the overhead? The benchmarks indicate that MySQL via ODBC is perhaps only
> 2x slower than MySQL alone, yet the performance we are experiencing is
> _many_ times slower than using Access via DAO. I'm wondering if the
> overhead has a lot to do with the fact that MySQL runs over a socket
> connection to localhost, whereas the Access jet engine was going directly
> to disk with each query/write?
AFAIK, there are two ODBC handlers for MySQL floating around, one with
debugging enabled (seems to be the default one), and one without. The
one with debugging is a magnitude slower than the other one. Make sure
that you use the faster one.
Bye,
Benjamin.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
