ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Benedict <paul4chris...@yahoo.com>
Subject Re: Bulk inserts
Date Thu, 03 Nov 2005 18:07:09 GMT
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