| 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 required | a b | 4 Apr |
| • Re: bulk insert optimization required | Mr.Dragomir Stanchev | 4 Apr |
| • Re: bulk insert optimization required | Warren Young | 5 Apr |
| • Re: bulk insert optimization required | a b | 5 Apr |
| • Re: bulk insert optimization required | Warren Young | 5 Apr |
| • Re: bulk insert optimization required | M Imran Siddiqui | 5 Apr |
| • Re: bulk insert optimization required | Warren Young | 6 Apr |
