Menu
▾
▴
Re: [Springframework-developer] Schema batch update operation
|
From: Thomas R. <tho...@tr...> - 2004-04-27 10:26:53
|
Using batch updates on Oracle usually provides a drastic performance improvement. Don't know if the same is true for other databases. I'll take a look at Keith's class in the sandbox later on this week. Thomas Rod Johnson wrote: >Mine uses JdbcTemplate.batchUpdate(), and the performance is brilliant. Mind >you the optimal batch size for what I need to do is 5,000. > >----- Original Message ----- >From: <tho...@tr...> >To: <spr...@li...> >Sent: Monday, April 26, 2004 10:04 PM >Subject: Re: [Springframework-developer] Schema batch update operation > > > > >>Keith, >> >>There is a batchUpdate() method on the JdbcTemplate that could be used. >> >> >Maybe > > >>we could have an SqlBatchUpdate() class that extends or mimics SqlUpdate >> >> >and > > >>uses batchUpdate() for the update calls to JdbcTemplate. >> >>Thomas >> >> >>Quoting Keith Donald <kd...@cs...>: >> >> >> >>>I think a SqlUpdate operation that can perform batch inserts would be a >>> >>> >nice > > >>>addition to the jdbc.object package. I'd like to be able to set the >>> >>> >batch > > >>>size, and then just call "batchInserter.insert(object)" and have the >>>SqlUpdate.update(Object[] Parameters) method automatically queue up sql >>>operations until the batch size is reached, and then commit 'em all, >>>starting over for the next batch.... (likely requiring a flush() call >>> >>> >once > > >>>there is no more data.) >>> >>>I'm essentially doing large data loads. Is there something like this >>>already? If not, I can write it. I could use it! >>> >>>Keith >>> >>> >>> >>> >>> >>>------------------------------------------------------- >>>This SF.net email is sponsored by: The Robotic Monkeys at ThinkGeek >>>For a limited time only, get FREE Ground shipping on all orders of $35 >>>or more. Hurry up and shop folks, this offer expires April 30th! >>>http://www.thinkgeek.com/freeshipping/?cpg=12297 >>>_______________________________________________ >>>Springframework-developer mailing list >>>Spr...@li... >>>https://lists.sourceforge.net/lists/listinfo/springframework-developer >>> >>> >>> >> >> >> >>------------------------------------------------------- >>This SF.net email is sponsored by: The Robotic Monkeys at ThinkGeek >>For a limited time only, get FREE Ground shipping on all orders of $35 >>or more. Hurry up and shop folks, this offer expires April 30th! >>http://www.thinkgeek.com/freeshipping/?cpg=12297 >>_______________________________________________ >>Springframework-developer mailing list >>Spr...@li... >>https://lists.sourceforge.net/lists/listinfo/springframework-developer >> >> >> > > > > >------------------------------------------------------- >This SF.net email is sponsored by: The Robotic Monkeys at ThinkGeek >For a limited time only, get FREE Ground shipping on all orders of $35 >or more. Hurry up and shop folks, this offer expires April 30th! >http://www.thinkgeek.com/freeshipping/?cpg=12297 >_______________________________________________ >Springframework-developer mailing list >Spr...@li... >https://lists.sourceforge.net/lists/listinfo/springframework-developer > > > > > |
