RE: Fastest connection type ... - Darren Hill - com.mysql.lists.dotnet

15 messages in com.mysql.lists.dotnetRE: Fastest connection type ...

From	Sent On	Attachments
Darren Hill	24 Apr 2006 05:22
Darren Hill	30 May 2006 07:21
Emanuel Oliveira	30 May 2006 07:29
Jorge Bastos	30 May 2006 08:40
Jorge Bastos	30 May 2006 08:50
Darren Hill	30 May 2006 10:34
Emanuel Oliveira	30 May 2006 10:43
Chris Herridge	02 Jun 2006 08:23
Darren Hill	02 Jun 2006 10:35
Chris Herridge	02 Jun 2006 10:51
Emanuel Oliveira	02 Jun 2006 11:13
Mike Hillyer	02 Jun 2006 11:42
Reggie Burnett	07 Aug 2006 15:40
Darren Hill	07 Aug 2006 15:46
Reggie Burnett	08 Aug 2006 08:32

Subject:	RE: Fastest connection type ...
From:	Darren Hill (dhi...@ormac.com)
Date:	06/02/2006 10:35:15 AM
List:	com.mysql.lists.dotnet

Note. MySQL does NOT support Stored Procedures over Named Pipes ... Right Emanuel? ;)

That should save you a few hours anyway.

________________________________________ Darren Hill - dhi...@ormac.com Ormac Content Management and IT Solutions www.ormac.com

(416) 410-1154 Ormac is proud to partner with: Allstream - www.allstream.com Route1 - www.route1.com

________________________________________

-----Original Message----- From: Chris Herridge [mailto:chr...@herridge.co.uk] Sent: June 2, 2006 11:23 AM To: dot...@lists.mysql.com Subject: RE: Fastest connection type ...

I fear i am being really rather stupid, but i'd like to try and use Connector.Net with named pipes rather than TCP connections to localhost (which seems a little silly)

However i am at a loss as to what connection string i should be using? - i can't find it *anywhere* in the documentation online, or in the CHM

I've been using Connector.Net and MySQL for all my projects for quite along time, and although i'm exciting by the new .net2 features round the corner my main concern is speed of it running rather than rapid development (That's why i love MySQL). I'm currently re-writing my DAL to use generics, transactions and object caching to speed up complex sites and programs that run off it - and i'm hpoing there's also speed gains to be made by named pipes!

Any client/server query optimisation advice is also is much apprechiated.

On another note; I know the mysql team are all very very busy people, is there anything that needs doing? - i'd be glad to lend a hand in anyway i can.

Many Thanks in advance.

don't know by head, but i know that is on the documentation in the connection string part (if im not wrong)

----- Original Message ----- From: "Chris Herridge" <chr...@herridge.co.uk> To: "Jorge Bastos" <mysq...@decimal.pt> Sent: Tuesday, May 30, 2006 4:43 PM Subject: RE: Fastest connection type ...

whats the conection string for a pipe using the .bet connector? i've always wanted to try it!

pipes

Quick one for you all,

I've got a client hosting their web app and MySQL on the same server. What connection type offers me the fastest speed? First answer gets a prize.

________________________________________ Darren Hill - dhi...@ormac.com Ormac Content Management and IT Solutions www.ormac.com

(416) 410-1154 Ormac is proud to partner with: Allstream - www.allstream.com Route1 - www.route1.com

________________________________________