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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > wrote: > > > On 11/3/05, Paul Benedict <[EMAIL PROTECTED]> > > 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 >
