You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Josef Wagner <Jo...@web.de> on 2006/05/17 16:08:59 UTC
problems width performance
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
4.30700@apache.org%3E)
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
de.on_ergy.lakon.data.LakonPersistenceBroker@1c1a68b
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: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: problems width performance
Posted by Armin Waibel <ar...@apache.org>.
Hi Josef,
>
> I have no idee, why my application takes 20 ms per object to store :o(
OJB is shipped with a simple multi-threaded test similar to your test.
Your can run this test out of the box against hsql, see
http://db.apache.org/ojb/docu/guides/performance.html#OJB+performance+in+multi-threaded+environments
Against hsql in-memory it takes a few ms to store an object, against
MaxDB it takes 24ms (mass test, batch-mode disabled, no statement pooling).
For upcoming OJB 1.0.5 I rewrote this document and made additional
performance test. With statement pooling enabled, batch mode enabled and
fastest PersistentField implementation it takes about 4ms to store one
object in multithreaded mass test against MaxDB.
So it strongly depends on the used configuration.
> I also wondering, that OJB stores bevor committing the transaction.
The PB-api does immediately execute all DB calls, no unit-of-work
concept is used (in contrast to odmg-api).
regards,
Armin
Josef Wagner wrote:
> 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
> 4.30700@apache.org%3E)
>
> 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
> de.on_ergy.lakon.data.LakonPersistenceBroker@1c1a68b
> 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: 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