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,
>
> Fred
MySQL C API library) while MyODBC has a few additional layers on top
of taht. Thus, connections through ODBC are always slower than direct
connections.
Instead of MyODBC, you may try Connector/.NET, which does not have any
intermediate libraries to slow down the data flow.
[url]http://dev.mysql.com/doc/refman/5.0/en/connector-net.html[/url]
Some tutorials here:
[url]http://www.vbmysql.com/articles[/url]
ciao
gmax
--
_ _ _ _
(_|| | |(_|>< The Data Charmer
_|
[url]http://datacharmer.blogspot.com/[/url]
Bookmarks