Re: I need 50.000 inserts / second

[Dan Nelson]

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