Hi,

I recompiled the subsonic source with the comercial CoreLab MySql Provider, because I am using it in several projects. I tested its connection time with a simple ExecuteScalar query repeating 1000x. Core Lab seems to be much faster than the connector from MySql. I tested the speed with the original subsonic .dll and wondered why it is slower in comparison to my simple select statement using CoreLab.

If anyone wants to test it:

1. Use the Corelab.Data and Corelab.MySql Assemblies instead of MySql.Data
2. Change the MySqlSchemaVariable.PARAMETER_PREFIX to ":"
3. In MySqlDataProvider.cs, change all Parameters starting with "?" to "@".
4. In Function AddParameters change replacing line to ...ParameterName.Replace('@', ':');
5. Thats all!

 CoreLab MySql Provider is too old use Mysql's official provider. Actually Mysql is buyed Corelab few year back and Mysql's official provide is extention of this.

I believe thats not right. They released the newest version on 26-Feb-08 and the provider has features MySql's never had. However, theres a comparison in the CoreLab documents:

 (I'm not from CoreLab, nore that I want you to buy this (expensive) tools. But there will be some developers working with CoreLab tools).