At 15:46 -0600 10/25/02, Jeff Mathis wrote:
forgive me.
i was initially using the perl DBI methods to load. I am not intimately
familiar with the inner workings of DBI, but obviously it must be doing
something if you say mysql does not support binding variables
(i am using 4.0.4). This is significantly faster than creating a new
prepared statement for every insert.
Right, it's the DBD::mysql driver that's emulating true parameter
binding. But it's still faster, as you observe, because you avoid the
prepare() call for all except the first insert statement.
Parameter binding by MySQL itself should probably appear sometime
in the 4.1.x series.
---------------------------------------------------------------------
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
