shirai wrote:It kind of sounds like you're talking about two separate things.> The problem is, the query overhead is 10x higher in MySQL than for MS SQL
"Overhead" to me is a memory usage issue--are you seeing high memory
usage when you use the MySQL driver? Speed is a separate issue.
What version of the MySQL driver are you using? How do you have it set> For example, I can run a very simple SELECT against both servers and I get
> these response times (running the query 100x and timing it)
> MS SQL Server: about 1ms per query
> MySQL: About 10ms per query
up in CF? I've always seen extremely comparable speeds between MySQL
and SQL Server. If anything MySQL can tend to be faster for certain
operations depending on the table type you use in MySQL (InnoDB vs. ISAM).
Latest meaning what version of the driver specifically? Is this MySQL> I'm using CFMX7 and the latest JDBC connector.
5? What table type are you using? How specifically do you have your
datasource defined in the CF administrator?
Adobe Community Expert - ColdFusion