Jeremy Zawodny writes:
>
> Monty recently proposed some changes to MySQL's client/server protocol
> which will enable "real" prepared statements. So I'd guess it'll
> happen somewhere in the 4.x tree.
>
> > Also just out of curiousity, how much of a performance hit does
> > mysql take in compiling an execution plan?
>
> My understanding is that it's not a big deal unless you want to really
> pound your server with queries. My gut feel is that the effort which
> goes into parsing the query is similar (in order of magnitude) to
> actually deciding how to execute the query. The query cache will help
> the parsing overhead and the prepared queries will help the execution
> planning.
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
>
> MySQL 3.23.41-max: up 44 days, processed 980,576,760 queries (254/sec. avg)
Just for the uninitiated :
MySQL++ supports prepared queries through it's template queries classes.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
