9 messages in com.mysql.lists.dotnetRE: Prepared Statements
FromSent OnAttachments
Ben Clewett01 Feb 2007 08:23 
Frank01 Feb 2007 14:08 
Reggie Burnett20 Feb 2007 05:42 
Ben Clewett21 Feb 2007 10:28 
Reggie Burnett21 Feb 2007 10:49 
Ben Clewett22 Feb 2007 00:28 
Reggie Burnett22 Feb 2007 05:38 
Ben Clewett23 Feb 2007 00:07 
Reggie Burnett23 Feb 2007 07:24 
Subject:RE: Prepared Statements
From:Reggie Burnett (reg@mysql.com)
Date:02/20/2007 05:42:46 AM
List:com.mysql.lists.dotnet

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,

Ben Clewett.

-- MySQL on .NET Mailing List For list archives: http://lists.mysql.com/dotnet To unsubscribe: http://lists.mysql.com/dotnet?unsub=reg@mysql.com