From: Dan Nelson
Date: May 31 2002 6:56pm
Subject: Re: I need 50.000 inserts / second
List-Archive: http://lists.mysql.com/mysql/110679
Message-Id: <20020531185612.GM45149@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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 :)

-- 
	Dan Nelson
	dnelson@stripped