cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andreas Hartmann <andr...@apache.org>
Subject Re: Memory and performance many new objects
Date Thu, 13 Aug 2009 15:09:49 GMT
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 committing every 1000 
> rows will allow Java side garbage collection on them, while the entire 
> spreadsheet will load atomically (unless of course your DB does not 
> support ACID transactions, i.e. MySQL MyISAM and such) :
> 
> http://cayenne.apache.org/doc/understanding-transactions.html

thanks a lot, that works like a charm!

> Also I should note that if you are not on Cayenne 3.0 yet, that has 
> self-cleaning DataContexts, you will also need to replace a DataContext 
> after each commit.

I'm using 3.0M6, but thanks for mentioning this.

-- Andreas


-- 
Andreas Hartmann, CTO
BeCompany GmbH
http://www.becompany.ch
Tel.: +41 (0) 43 818 57 01


Mime
View raw message