IBatis is a wonderful OR mapper. But if you do not see any O while accessing your db, there is perhaps no need to use it.
----- Original Message ---- From: Christopher Lamey <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, July 22, 2008 6:32:08 PM Subject: Re: ibatis+springframework for millions data loading On 7/22/08 4:24 PM, "Clinton Begin" <[EMAIL PROTECTED]> wrote: > True, other tools may be better... > > But with a RowHandler, iBATIS could easily meet this requirement. I've used > iBATIS RowHandlers for ETL type stuff and achieved crazy performance with > batch updates. 15,000 records per second on the Netflix prize data. Definitely, I've used rowhandlers in iBATIS for similar stuff with millions of rows as well. Complicated data transforms or the lack of ability to do command line stuff for various reasons have usually been why I've gone with a RowHandler. But if I'm just copying data from database a to database b and I don't need complicated transformations or handling, I've never seen anything faster than the database's native bulk loaders (sqlldr, bc, copy, etc.) Cheers, Chris
