On Thu, Apr 05, 2001 at 07:50:24PM +0300, Heikki Tuuri wrote:
>
> for ($j = 0; $j < 100000; $j = $j + 1) {
>
> $dbh->do("insert into speed1 values ($j, $j, $j)");
> }
That would run faster if you do a prepare with placeholders outside
the loop and then just use $sth->execute($j, $j, $j) inside.
That would save you the DBI statement handle creation/destruction
overhead that you're paying for each insert when using do().
Tim.
---------------------------------------------------------------------
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
