List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:May 31 2002 6:56pm
Subject:Re: I need 50.000 inserts / second
View as plain text  
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
Thread
I need 50.000 inserts / secondCesar Mello - Axi31 May
  • Re: I need 50.000 inserts / secondJeremy Zawodny31 May
  • Re: I need 50.000 inserts / secondSteve Edberg31 May
  • Re: I need 50.000 inserts / secondHarald Fuchs31 May
  • Re: I need 50.000 inserts / secondMark31 May
    • Re: I need 50.000 inserts / secondBenjamin Pflugmann31 May
    • Re: I need 50.000 inserts / secondDan Nelson31 May
      • Re: I need 50.000 inserts / secondJeremy Zawodny1 Jun
  • Re: I need 50.000 inserts / secondMark31 May
  • Re: I need 50.000 inserts / secondCesar Mello - Axi31 May
    • Re: I need 50.000 inserts / secondmos2 Jun
  • Re: I need 50.000 inserts / secondRichard Clarke2 Jun
RE: I need 50.000 inserts / seconddomi31 May
  • Re: I need 50.000 inserts / secondCesar Mello - Axi31 May
    • Re: I need 50.000 inserts / secondT├Ánu Samuel31 May
    • Re: I need 50.000 inserts / secondBrent Baisley31 May