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" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> 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 : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
