List:MySQL++« Previous MessageNext Message »
From:Warren Young Date:April 4 2007 11:07pm
Subject:Re: bulk insert optimization required
View as plain text  
Mr.Dragomir Stanchev wrote:
> 
> You just have to execute the insert query by yourself -
> 
> Instead of "insert into table values(?,?,?)" you can do "insert into table
> values(?,?,?),(?,?,?),(?,?,?),(?,?,?).....".

It wouldn't be hard to substitute this query style in for the current 
logic in Query::insert(iter, iter).  Why don't you try it and report 
back with the results, Imran?  If it gives a decent improvement, please 
submit a patch against the current svn version.
Thread
bulk insert optimization requireda b4 Apr
  • Re: bulk insert optimization requiredMr.Dragomir Stanchev4 Apr
    • Re: bulk insert optimization requiredWarren Young5 Apr
      • Re: bulk insert optimization requireda b5 Apr
        • Re: bulk insert optimization requiredWarren Young5 Apr
          • Re: bulk insert optimization requiredM Imran Siddiqui5 Apr
            • Re: bulk insert optimization requiredWarren Young6 Apr