RE: Connectionstring parameter for faster connection's open - Kevin Turner - com.mysql.lists.dotnet

5 messages in com.mysql.lists.dotnetRE: Connectionstring parameter for fa...

From	Sent On	Attachments
Stefano Del Furia	01 Nov 2006 05:21
Kevin Turner	01 Nov 2006 05:28
Stefano Del Furia	01 Nov 2006 05:36
Kevin Turner	01 Nov 2006 06:04
Stefano Del Furia	01 Nov 2006 06:18

Subject:	RE: Connectionstring parameter for faster connection's open
From:	Kevin Turner (kevi...@coraltree.co.uk)
Date:	11/01/2006 05:28:06 AM
List:	com.mysql.lists.dotnet

Rightly or wrongly, with 1.0.6 we would use:

Server=nemo;Database=SLAE;Uid=root;Pwd=xxx;Pooling=true;Cache server configuration=yes;Reset pooled connections=no

However, when we use the same string with 1.0.8 it fails miserably. Haven't had time to work out why yet. In fact we can't seem to get 1.0.8 working with or without these extra two connection string parms.

-----Original Message----- From: Stefano Del Furia [mailto:del...@edudotnet.it] Sent: 01 November 2006 13:22 To: dot...@lists.mysql.com Subject: Connectionstring parameter for faster connection's open

Hi all, i'm using the connector for an OpenSource project about Squid's log analyzer.

http://sourceforge.net/projects/slae

In my software i support Access, SqlServer and MySql. During a test's session on performace i have notice that MySQL was 10 times slower than SqlServer. After some test i have found that the problem could be on connection open due to my DataTier architecture. Searchinig on internet i have found that the Connector do some check on

every connection's open, but that there are some connectionstring's parameters that i can set for avoid this.

http://forums.mysql.com/read.php?38,42589,56988#msg-56988 http://forums.mysql.com/read.php?38,42589,63917#msg-63917

I have tried to use these parameter but i get always an error. So, my connection string is, actually:

Server=nemo;Database=SLAE;Uid=root;Pwd=xxx;Pooling=true;

What must i use for getting faster connection opening ??? Thanks in advance Stefano