On Fri, Apr 06, 2001 at 06:51:39AM -0700, Martin Hubert wrote:
> But does that really change anything on the database server side ?
> In other words is MySQL doing anything with respect to using prepared
> statements ?
No. (Sadly MySQL doesn't support prepared statements. Pity.)
But if you're measuring the elapsed time of the perl script to do
benchmarks, as here, then it'll give a more accurate picture by
removing irrelevant overheads.
Tim.
> -----Original Message-----
> From: Tim Bunce [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 06, 2001 3:01 AM
> To: Heikki Tuuri
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Mysql speed :)
>
>
> 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
---------------------------------------------------------------------
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
