Re: Memory and performance many new objects

From: Andreas Hartmann (andrea..pache.org)
Date: Thu Aug 13 2009 - 11:09:49 EDT

  • Next message: Joe Baldwin: "Memory Management Practices"

    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

    This archive was generated by hypermail 2.0.0 : Thu Aug 13 2009 - 11:10:47 EDT