On Fri, May 31, 2002 at 01:56:12PM -0500, Dan Nelson wrote: > In the last episode (May 31), Mark said: > > Cesar, you really should consider using placeholders and bind_param > > (if available). Without using placeholders, the insert statement will > > contain the literal values to be inserted and has to be re-prepared > > and re-executed for each row. With placeholders, the insert statement > > only needs to be prepared once. The bind values for each row can be > > given to the execute method each time it's called. By avoiding the > > need to re-prepare the statement for each row, the application > > typically runs many times faster. > > Mysql does not support bindings or preparing. Each statement is > fully parsed. Whatever you think perl is doing, it isn't :)
Correct, but... 1. When the MySQL protocol does support binding, then applications coded to use them will suddenly speed up. 2. Using bind parameters and prepared statements with Perl requires less overhead and makes the Perl code faster. 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.51: up 2 days, processed 55,486,250 queries (282/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
