Mailing-List: contact ojb-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "OJB Users List" <ojb-user@db.apache.org>
From: "ghielard" <ghielard@deliasystems.com>
To: "OJB Users List" <ojb-user@db.apache.org>
Subject: RE: Antwort: WHY OJB SPEND MORE AND MORE TIME TO STORE OBJECTS ?
Date: Thu, 4 Dec 2003 17:27:52 +0100
Message-ID: <EEEAJPMLGDAJIFNMFNGMAEIFCAAA.ghielard@deliasystems.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
In-Reply-To: <00a001c3ba7c$32e31600$0300a8c0@ford>
Importance: Normal

it starts normally with a good speed and it is slowing down even if the
database is empty or not.
The time is always the same, about 40 min for the first sequence, 50 min for
the second one etc ...
the increasing is between 5 or 20 secondes for each storing sequence. A
storing sequence stores about 800 objects .

To be sure that the transaction is closed, i used a new PersistenceBroker
for each storing sequence after commmit and close the old PersistenceBroker.

i don't use proxy in my repository.

-----Message d'origine-----
De : Daniel Perry [mailto:d.perry@netcase.co.uk]
Envoy� : jeudi 4 d�cembre 2003 16:35
� : OJB Users List
Objet : Re: Antwort: WHY OJB SPEND MORE AND MORE TIME TO STORE OBJECTS ?


If you leave data in your database, and run the test again, does it start
quickly or slowly?
This should tell if the problem is to do with size of database, or to do
with the code.

any unproxied references in repository.xml?
are you closing transactions properly?

Daniel.

----- Original Message -----
From: "ghielard" <ghielard@deliasystems.com>
To: "OJB Users List" <ojb-user@db.apache.org>
Sent: Thursday, December 04, 2003 3:23 PM
Subject: RE: Antwort: WHY OJB SPEND MORE AND MORE TIME TO STORE OBJECTS ?


> There is no index in my database, only primary and foreign keys. The
> phenomena still the same with an Oracle 8i database or a SQLServer 2000
> database.
> I removed every attributes in my repository_user.xml using datatype CLOB
> (ora) or TEXT (SQLServer2000). I removed also every conversions in this
> file, and all "reference descriptor". i thougth also it was my database
but
> even if i don't delete all datas before running my application. it started
> with a good speed but it goes wrong.
> I removed all datas in my database before each storing sequence. The
problem
> lasts.
>
> -----Message d'origine-----
> De : RBaron-Riege@intersoft.de [mailto:RBaron-Riege@intersoft.de]
> Envoye : jeudi 4 decembre 2003 15:50
> A : OJB Users List
> Objet : Antwort: WHY OJB SPEND MORE AND MORE TIME TO STORE OBJECTS ?
>
>
> Hi,
> is it possible that you have an index on that table???
> If you build a complex index every time you insert a set of data your
> index takes more time.
>
> cheers,
> Ralf
>
> "ghielard" <ghielard@deliasystems.com> schrieb am 04.12.2003 15:23:45:
>
> > Hi everybody,
> >
> > i have an important problem of performance.
> > I'd tried every type of object cache (default,empty,perBroker),
> > i instanciated a new PersistenceBroker instance each time i had a
> storing
> > sequence in my java Code, or I kept the same for all storing sequence.
> > I did it the same thing with MetadataManager.
> > But it isn't better. OJB is slower every time is storing an object,
> about
> > few seconds more longer.
> > As i store thousand objects, at the end OJB is very slow.
> > I think there is also a problem of memory. So i run the garabage
> collector
> > after each storing sequence, and the clearCache() of the instance of
> > PersistenceBroker.
> > I use a transaction for each storing sequence.
> >
> > is there somebody who can help me?
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: ojb-user-help@db.apache.org
> >
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org