MySQL Forums
Forum List  »  Optimizer & Parser

Re: my boss says mysql is not upto standard: Please reply urgent
Posted by: Toa Sty
Date: February 06, 2007 09:31AM

Hi Jatin,

Not an area that I'm particularly familiar with, but a quick search and this turned up:
http://dev.mysql.com/doc/refman/5.1/en/c-api-prepared-statements.html
or, for MySQL 5.0:
http://dev.mysql.com/doc/refman/5.0/en/c-api-prepared-statements.html

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

So it looks like it's supported. OTOH, your client library might not have support for this (I'm told that some just convert prepared statements to normal full SQL statements on the client), and anyway I'd be very surprised if you saw much benefit performance-wise, especially given that if you use prepared statements the query cache won't get used.

Like I said, I've not looked at prepared statements much with MySQL, so you're better off testing your app and seeing whether you benefit.

Hopefully someone with a deeper understanding will add to this for you.

Cheers,
Toasty

-----------------------------------------
email: 'toasty'*3 at gmail

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: my boss says mysql is not upto standard: Please reply urgent
1935
February 06, 2007 09:31AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.