Hello Armin,
you have written in the mailing list, that it takes around 20 sec. to store
10000 objects (is 0,5 obj in 1 ms.).
(http://mail-archives.apache.org/mod_mbox/db-ojb-user/200408.mbox/%3C411780E
[EMAIL PROTECTED])
In my testszenario, when I logging width timestamp before calling store and
also after storing, I see a difference from at least 10 ms till 50 ms for
each object.
Here my szenario
###########################
# repository_language.xml #
###########################
<class-descriptor
class="de.on_ergy.lakon.data.model.Language"
table="language">
<field-descriptor name="objId" column="obj_id" jdbc-type="INTEGER"
primarykey="true"></field-descriptor>
<field-descriptor name="lang" column="lang " jdbc-type="CHAR"
length="5"></field-descriptor>
<field-descriptor name="langDesc" column="lang_desc" jdbc-type="CHAR"
length="30"></field-descriptor>
<field-descriptor name="langCode" column="lang_code" jdbc-type="CHAR"
length="4"></field-descriptor>
<field-descriptor name="activ" column="activ" jdbc-type="BOOLEAN"
></field-descriptor>
</class-descriptor>
##################
# java test code #
##################
broker = getBroker();
log.info("start begin transaction -> " + new Timestamp(new
Date().getTime()));
broker.beginTransaction();
log.info("end beginn transaction -> " + new Timestamp(new
Date().getTime()));
for (int i = 1; i <= 10; i++) {
log.info("start store -> " + new Timestamp(new Date().getTime()));
Language lang = new Language();
lang.setObjId(new Integer(i));
lang.setLang("TE_ST");
lang.setLangDesc("description");
lang.setLangCode("ENG");
lang.setActiv(new Boolean(true));
broker.store(lang);
log.info("end store -> " + new Timestamp(new Date().getTime()));
}
log.info("start commit transaction -> " + new Timestamp(new
Date().getTime()));
broker.commitTransaction();
log.info("end commit transaction -> " + new Timestamp(new
Date().getTime()));
##################
# logging output #
##################
Start beginn transaktion -> 2006-05-17 13:23:41.688
End beginn transaktion -> 2006-05-17 13:23:41.698
Start broker store -> 2006-05-17 13:23:41.698
Specified cache class org.apache.ojb.broker.cache.ObjectCacheEmptyImpl does
not implement interface org.apache.ojb.broker.cache.ObjectCacheInternal and
will be wrapped by a helper class
End broker store -> 2006-05-17 13:23:41.748
Start broker store -> 2006-05-17 13:23:41.748
End broker store -> 2006-05-17 13:23:41.769
Start broker store -> 2006-05-17 13:23:41.769
End broker store -> 2006-05-17 13:23:41.799
Start broker store -> 2006-05-17 13:23:41.799
End broker store -> 2006-05-17 13:23:41.809
Start broker store -> 2006-05-17 13:23:41.809
End broker store -> 2006-05-17 13:23:41.819
Start broker store -> 2006-05-17 13:23:41.829
End broker store -> 2006-05-17 13:23:41.839
Start broker store -> 2006-05-17 13:23:41.839
End broker store -> 2006-05-17 13:23:41.869
Start broker store -> 2006-05-17 13:23:41.869
End broker store -> 2006-05-17 13:23:41.879
Start broker store -> 2006-05-17 13:23:41.899
Start creating new ObjectCache instance
Instantiate new org.apache.ojb.broker.cache.CacheDistributor for PB instance
[EMAIL PROTECTED]
New ObjectCache instance was created
Specified cache class org.apache.ojb.broker.cache.ObjectCacheEmptyImpl does
not implement interface org.apache.ojb.broker.cache.ObjectCacheInternal and
will be wrapped by a helper class
End broker store -> 2006-05-17 13:23:42.019
Start commit transaktion -> 2006-05-17 13:23:42.039
End commit transaktion -> 2006-05-17 13:23:42.039
I have no idee, why my application takes 20 ms per object to store :o(
I also wondering, that OJB stores bevor committing the transaction.
I Developing an Eclipse RCP width hsqldb and postgres and OJB 1.0.3
Thanks a lot for your help!
Josef Wagner
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
