ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <lmead...@apache.org>
Subject Re: Bulk inserts
Date Thu, 03 Nov 2005 18:29:36 GMT
I think I'd look for a native database tool for this - most vendors
provide bulk-loading tools.

I think iBATIS is cool, but a golden hammer it isn't. ;-)

Larry


On 11/3/05, Paul Benedict <paul4christ79@yahoo.com> wrote:
> How does it compare to bulk insert? It's faster.
> Making 1000 round trips to the database is slower than
> 1.
>
> Try it out on your database. If it doesn't work, then
> you must do a for loop.
>
> --- Michael Campbell <michael.campbell@gmail.com>
> wrote:
>
> > On 11/3/05, Paul Benedict <paul4christ79@yahoo.com>
> > wrote:
> > > Yes,
> > >
> > > SQL has a notation to INSERT multiple entries at
> > once.
> > > What you want to do is build a statement like the
> > > following:
> > >
> > > INSERT INTO fruit (id, name) VALUES (0, 'Pear'),
> > (1,
> > > 'Apple'), (2, 'Peach')
> >
> >
> > Is that standard ANSI SQL?  I know MySql supports
> > that syntax, but
> > wasn't aware that many (any?) others did.
> >
> > --
> > I tend to view "truly flexible" by another term:
> > "Make everything
> > equally hard". -- DHH
> >
>
>
>
>
> __________________________________
> Yahoo! FareChase: Search multiple travel sites in one click.
> http://farechase.yahoo.com
>

Mime
View raw message