hello,
I am very greatful for Mr.Dragomir Stanchev and Mr. Warren Young 's
kind reply to my problem.
Dear gentlemen, my supervisor has given me an urgent task and
currently i am working on it.
As soon as i complete it, i shall switch on bulk insert and inform you
about my progress.
If "Prepare Statement" do not work according to the performance
required then probably i shall explore the source code of LOAD DATA
INFILE.
Once again, thanks for your reply.
With best regards,
Imran Siddiqui
On 4/5/07, Warren Young <mysqlpp@stripped> wrote:
> 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.
>
> --
> MySQL++ Mailing List
> For list archives: http://lists.mysql.com/plusplus
> To unsubscribe: http://lists.mysql.com/plusplus?unsub=1
>
>
