Re: Mysql Innodb performance slow

[Dan Nelson]

In the last episode (Oct 25), Jeff Mathis said:
> I'll agree to this somewhat:
> 
> (1) always bind your variables. whatever code you are using to do your
> inserts, the fewer prepared statements you can make the better.
> 
> for example:
> insert into TableName (col1, col2, col2, col4) values (?,?,?,?)
> 
> then, once you have a prepared statment, do a loop and insert.

Note that mysql does not support bind variables.  If you think you're
using them, whatever API you are using is filling them in before
sending the statement to mysql.  Bind variables do solve quoting
problems, though, so if you use them, know why you're using them :)

-- 
	Dan Nelson
	dnelson@stripped