Re: Memory and performance many new objects

2009-08-13 Thread Andreas Hartmann
Hi Andrus, Andrus Adamchik schrieb: On Aug 13, 2009, at 12:36 PM, Andreas Hartmann wrote: Of course I could commit the transaction each 1000 rows or so, but I'd rather commit the whole spreadsheet to the DB in a single transaction. You can use user-defined transaction scope, then committi

Re: Memory and performance many new objects

2009-08-13 Thread Andrus Adamchik
On Aug 13, 2009, at 12:36 PM, Andreas Hartmann wrote: Of course I could commit the transaction each 1000 rows or so, but I'd rather commit the whole spreadsheet to the DB in a single transaction. You can use user-defined transaction scope, then committing every 1000 rows will allow Jav

Memory and performance many new objects

2009-08-13 Thread Andreas Hartmann
Hi everyone, I'm facing the following situation: I'm importing arbitrary spreadsheets with quite large numbers of rows. A row represents a recipient of a mailing. The spreadsheet can contain arbitrary columns, so I chose the following entity model: * RecipientSet -> m Fields (i.e. spreadshe