Re: I need 50.000 inserts / second

[Jeremy Zawodny]

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, <jzawodn@stripped>
Technical Yahoo - Yahoo Finance
Desk: [phone]   Fax: [phone]   Cell: [phone]

MySQL 3.23.51: up 2 days, processed 55,486,250 queries (282/sec. avg)