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]
