Fred wrote:MySQL Control Center uses direct connections (i.e. through calls to> Hi,
> I have a website hosted on two servers bi-xeon(Win2003, 1GB RAM) : one
> for the website, one for MySQL 4.
> I access MySQL from my ASP Pages with myOBDC.
> I noticed a strange problem :
> When I execute a quite complex query using MySQL control center directly
> on the MySQL server, I have the following execution times :
> - With ODBC turned off (ie the website is stopped, so I have no
> connections from the website to MySQL) : 0.1 sec
> - With MyODBC on (15 connections simultaneously) : 1,5sec
> Do you have any idea of where the problem can come from and how I can
> solve it ?
> Thanks for your help,
MySQL C API library) while MyODBC has a few additional layers on top
of taht. Thus, connections through ODBC are always slower than direct
Instead of MyODBC, you may try Connector/.NET, which does not have any
intermediate libraries to slow down the data flow.
Some tutorials here:
_ _ _ _
(_|| | |(_|>< The Data Charmer