Hi!
>>>>> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> 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. <cut> A small additional comment: The prepared queries biggest advantage that one can send parameters in binary format, without quoting, between the server and client. This will speed up the communication protocol a great deal. Regards, Monty --------------------------------------------------------------------- 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