Re: Optimize Insert

In article <41e3ff0a$1_1_at_127.0.0.1>, damorgan_at_x.washington.edu says...
> Sascha Bahl wrote:
>
> > Hello!
> >
> > How can i optimize inserts into table? Under MySQL i can use value lists
> > to collect many of records. How can i insert many of record in one
> > insert statement?
> >
> > Thanks
> >
> > Sascha Bahl
>
> BEGIN
> INSERT
> INSERT
> ...
> COMMIT;
> END;
> /
>
>

Thank you! My data import is faster now. From 20 min to 6 min. Received on Wed Jan 12 2005 - 07:25:05 CST