Re: my boss says mysql is not upto standard: Please reply urgent

[Toa Sty]

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