On Sat, Oct 20, 2001 at 07:40:18PM +0100, Mark Maunder wrote: > Jeremy Zawodny wrote: > > > > so the database server can reuse the old execution plan. Let me > > > know if you want a example. > > > > That's true for some database servers but not MySQL (yet). > > I wasn't aware of that - thanks Jeremy. Any ETA as to when this > might be implemented? (part of version 4?)
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) --------------------------------------------------------------------- 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
