Re: [Springframework-developer] Schema batch update operation

[Rod J. <rod...@in...>]

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
>