Re: Prepared Statements - Ben Clewett - com.mysql.lists.dotnet

9 messages in com.mysql.lists.dotnetRe: Prepared Statements

From	Sent On	Attachments
Ben Clewett	01 Feb 2007 08:23
Frank	01 Feb 2007 14:08
Reggie Burnett	20 Feb 2007 05:42
Ben Clewett	21 Feb 2007 10:28
Reggie Burnett	21 Feb 2007 10:49
Ben Clewett	22 Feb 2007 00:28
Reggie Burnett	22 Feb 2007 05:38
Ben Clewett	23 Feb 2007 00:07
Reggie Burnett	23 Feb 2007 07:24

Subject:	Re: Prepared Statements
From:	Ben Clewett (be...@roadrunner.uk.com)
Date:	02/21/2007 10:28:49 AM
List:	com.mysql.lists.dotnet

Hi Reggie,

I understand about the problem.

Oddly when I went on the MySql 4-day tuning course, the impression I got was that there were definitely two kinds of server-side prepared statement.

One in SQL syntax which is a half-way implementation. Using the standard text transport protocol and standard SQL.

The other which uses a fast binary protocol and is the full implementation...

I believe you fully when you say there is only one, but I am interested to know where my miss-information came from, and what MySql.NET is....

Anyway, I greatly look forward to trying the c# when available, and hope this will be available for .NET 1.1...

Regards,

Ben

Reggie Burnett wrote:

Ben

MySQL supports only one type of prepared statement and that is server side. The second URL you included just describes the SQL syntax for the PS. Frank is also right when he says that there are currently some issues with PS and we have provided a connection string option to disable them (this is on by default).

Reggie

Dear MySql.NET,

I have been using MySql.NET on Mono and find it easy to use and fast.

I read that the MySql.NET API uses prepared statements. I'm trying to find out a bit more about this. I know MySQL has two types of Server Side Prepared Statement. There are also Client Side prepared statements which are external to MySQL.

One Server Site Prepared Statement uses a custom binary protocol for fast low bandwidth data transfer:

http://dev.mysql.com/doc/refman/5.0/en/c-api-prepared-statements.html

The other is formed in SQL and uses the standard text protocol:

http://dev.mysql.com/doc/refman/5.0/en/sqlps.html

But both have a limitation that they doesn't use the Query Cache:

http://dev.mysql.com/doc/refman/5.0/en/c-api-prepared-statement- problems.html

My question is, which does .NET use? Can I switch between them depending on the behaviour I want?

Thanks for any help you can give me,