List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:October 25 2002 9:24pm
Subject:Re: Mysql Innodb performance slow
View as plain text  
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
Thread
Mysql Innodb performance slowJeroen Geusebroek25 Oct
  • Re: Mysql Innodb performance slowRichard Clarke25 Oct
  • Re: Mysql Innodb performance slowJeff Mathis26 Oct
    • Re: Mysql Innodb performance slowDan Nelson28 Oct
  • Re: Mysql Innodb performance slowJeff Mathis26 Oct
    • Re: Mysql Innodb performance slowPaul DuBois27 Oct
  • Re: Mysql Innodb performance slowMark Matthews26 Oct
    • Re: Mysql Innodb performance slowDavid Lloyd26 Oct
  • Re: Mysql Innodb performance slowMark Matthews27 Oct
RE: Mysql Innodb performance slowJeroen Geusebroek26 Oct
  • Re: Mysql Innodb performance slowMark Matthews26 Oct