Re: [OJB-developers] HSQLDB performance also bad

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Hi Ricardo,

Of course I did not mention on which machine I was running my tests. It=20
is a lapttop with an AMD AThlon 1GHz CPU with 256 MB Ram,
Runninng linux and WinXP.

I attached a new html file assembling some more test results. They all=20
show a reasonable performance.

Your HSQLDB results are *really bad*. I have no Idea what might cause=20
this. Our hardware is quite similar?!

Ricardo Arg=FCello wrote:

> Hello,
>=20
> This is the performance results using the "embedded" hsql database. I r=
an them out of the box (unzipped the OJB 0.7.3434 src file), with no othe=
r process running.
>=20
> Hardware : Intel Pentium III 1 GHz, 256 MB RAM
> OS: Microsoft Windows 2000 SP2
> JDK: Sun 1.3.1_01
> OJB: 0.7.343
> DB: HSQLDB
>=20
> -------------------------------------------------------------
> performance:
>       [ojb] [BOOT] INFO: OJB.properties: file:/C:/Java/ojbperftest/ojb-=
0.7.343/b
> uild/test/ojb/OJB.properties
>       [ojb] .[performance] INFO:
>       [ojb] [performance] INFO: inserting 10000 Objects: 68859 msec
>       [ojb] [performance] INFO: updating 10000 Objects: 79654 msec
>       [ojb] [performance] INFO: querying 10000 Objects: 21981 msec
>       [ojb] [performance] INFO: querying 10000 Objects: 431 msec
>       [ojb] [performance] INFO: fetching 10000 Objects: 7441 msec
>       [ojb] [performance] INFO: deleting 10000 Objects: 38425 msec
>       [ojb] [performance] INFO:
>       [ojb] [performance] INFO: inserting 10000 Objects: 61659 msec
>       [ojb] [performance] INFO: updating 10000 Objects: 83019 msec
>       [ojb] [performance] INFO: querying 10000 Objects: 22352 msec
>       [ojb] [performance] INFO: querying 10000 Objects: 411 msec
>       [ojb] [performance] INFO: fetching 10000 Objects: 8622 msec
>       [ojb] [performance] INFO: deleting 10000 Objects: 37604 msec
>       [ojb] [performance] INFO:
>       [ojb] [performance] INFO: inserting 10000 Objects: 68679 msec
>       [ojb] [performance] INFO: updating 10000 Objects: 82068 msec
>       [ojb] [performance] INFO: querying 10000 Objects: 21992 msec
>       [ojb] [performance] INFO: querying 10000 Objects: 410 msec
>       [ojb] [performance] INFO: fetching 10000 Objects: 8943 msec
>       [ojb] [performance] INFO: deleting 10000 Objects: 37835 msec
>       [ojb]
>       [ojb] Time: 654.151
>       [ojb]
>       [ojb] OK (1 tests)
>       [ojb]
>      [jdbc] [BOOT] INFO: OJB.properties: file:/C:/Java/ojbperftest/ojb-=
0.7.343/b
> uild/test/ojb/OJB.properties
>      [jdbc] .[performance] INFO:
>      [jdbc] [performance] INFO: inserting 10000 Objects: 18306 msec
>      [jdbc] [performance] INFO: updating 10000 Objects: 29653 msec
>      [jdbc] [performance] INFO: querying 10000 Objects: 15893 msec
>      [jdbc] [performance] INFO: querying 10000 Objects: 14551 msec
>      [jdbc] [performance] INFO: fetching 10000 Objects: 490 msec
>      [jdbc] [performance] INFO: deleting 10000 Objects: 9755 msec
>      [jdbc] [performance] INFO:
>      [jdbc] [performance] INFO: inserting 10000 Objects: 18066 msec
>      [jdbc] [performance] INFO: updating 10000 Objects: 29001 msec
>      [jdbc] [performance] INFO: querying 10000 Objects: 14601 msec
>      [jdbc] [performance] INFO: querying 10000 Objects: 14571 msec
>      [jdbc] [performance] INFO: fetching 10000 Objects: 551 msec
>      [jdbc] [performance] INFO: deleting 10000 Objects: 9794 msec
>      [jdbc] [performance] INFO:
>      [jdbc] [performance] INFO: inserting 10000 Objects: 18216 msec
>      [jdbc] [performance] INFO: updating 10000 Objects: 32197 msec
>      [jdbc] [performance] INFO: querying 10000 Objects: 15783 msec
>      [jdbc] [performance] INFO: querying 10000 Objects: 15722 msec
>      [jdbc] [performance] INFO: fetching 10000 Objects: 1633 msec
>      [jdbc] [performance] INFO: deleting 10000 Objects: 9373 msec
>      [jdbc]
>      [jdbc] Time: 385.254
>      [jdbc]
>      [jdbc] OK (1 tests)
>      [jdbc]
>=20
> BUILD SUCCESSFUL
>=20
> Total time: 18 minutes 41 seconds
> -------------------------------------------------------------
>=20
>=20
> These results also look very bad, compared to what Thomas sent me for H=
SQL:
>=20
> Mine:
>       [ojb] Time: 654.151
>      [jdbc] Time: 385.254
>=20
> Thomas's
>       [ojb] Time: 17.435
>      [jdbc] Time: 12.065
>=20
>=20
> How can this be possible????????
>=20
>=20
>=20
> I ran the test (OJB + HSQL) in ANOTHER machine, a Pentium 500 MHz + 256=
MB RAM, and got these also dissapointing results:
>=20
> performance:
>       [ojb] [BOOT] INFO: OJB.properties: file:/C:/ojb/build/test/ojb/OJ=
B.propert
> ies
>       [ojb] .[performance] INFO:
>       [ojb] [performance] INFO: inserting 10000 Objects: 84774 msec
>       [ojb] [performance] INFO: updating 10000 Objects: 94948 msec
>       [ojb] [performance] INFO: querying 10000 Objects: 44485 msec
>       [ojb] [performance] INFO: querying 10000 Objects: 350 msec
>       [ojb] [performance] INFO: fetching 10000 Objects: 2643 msec
>       [ojb] [performance] INFO: deleting 10000 Objects: 26018 msec
>       [ojb] [performance] INFO:
>       [ojb] [performance] INFO: inserting 10000 Objects: 81099 msec
>       [ojb] [performance] INFO: updating 10000 Objects: 97512 msec
>       [ojb] [performance] INFO: querying 10000 Objects: 44915 msec
>       [ojb] [performance] INFO: querying 10000 Objects: 341 msec
>       [ojb] [performance] INFO: fetching 10000 Objects: 3345 msec
>       [ojb] [performance] INFO: deleting 10000 Objects: 25597 msec
>       [ojb] [performance] INFO:
>       [ojb] [performance] INFO: inserting 10000 Objects: 85965 msec
>       [ojb] [performance] INFO: updating 10000 Objects: 96331 msec
>       [ojb] [performance] INFO: querying 10000 Objects: 44264 msec
>       [ojb] [performance] INFO: querying 10000 Objects: 341 msec
>       [ojb] [performance] INFO: fetching 10000 Objects: 2934 msec
>       [ojb] [performance] INFO: deleting 10000 Objects: 24806 msec
>       [ojb]
>       [ojb] Time: 762.521
>       [ojb]
>       [ojb] OK (1 tests)
>       [ojb]
>      [jdbc] [BOOT] INFO: OJB.properties: file:/C:/ojb/build/test/ojb/OJ=
B.propert
> ies
>      [jdbc] .[performance] INFO:
>      [jdbc] [performance] INFO: inserting 10000 Objects: 20159 msec
>      [jdbc] [performance] INFO: updating 10000 Objects: 30284 msec
>      [jdbc] [performance] INFO: querying 10000 Objects: 21091 msec
>      [jdbc] [performance] INFO: querying 10000 Objects: 20540 msec
>      [jdbc] [performance] INFO: fetching 10000 Objects: 311 msec
>      [jdbc] [performance] INFO: deleting 10000 Objects: 7821 msec
>      [jdbc] [performance] INFO:
>      [jdbc] [performance] INFO: inserting 10000 Objects: 24616 msec
>      [jdbc] [performance] INFO: updating 10000 Objects: 31246 msec
>      [jdbc] [performance] INFO: querying 10000 Objects: 20810 msec
>      [jdbc] [performance] INFO: querying 10000 Objects: 20590 msec
>      [jdbc] [performance] INFO: fetching 10000 Objects: 1062 msec
>      [jdbc] [performance] INFO: deleting 10000 Objects: 7841 msec
>      [jdbc] [performance] INFO:
>      [jdbc] [performance] INFO: inserting 10000 Objects: 25067 msec
>      [jdbc] [performance] INFO: updating 10000 Objects: 33348 msec
>      [jdbc] [performance] INFO: querying 10000 Objects: 21401 msec
>      [jdbc] [performance] INFO: querying 10000 Objects: 21822 msec
>      [jdbc] [performance] INFO: fetching 10000 Objects: 711 msec
>      [jdbc] [performance] INFO: deleting 10000 Objects: 8833 msec
>      [jdbc]
>      [jdbc] Time: 444.368
>      [jdbc]
>      [jdbc] OK (1 tests)
>      [jdbc]
> ----------------------------------------------------------------
>=20
> Totals:
>       [ojb] Time: 762.521
>      [jdbc] Time: 444.368
>=20
>=20
>=20
> I ran the test in my 1GHz machine, but with OJB 0.7.325 (just to find o=
ut if OJB had become slower):
>=20
> HSQL + OJB 0.7.325:
> --------------------------------------------------
> performance:
>       [ojb] [BOOT] INFO: OJB.properties: file:/C:/Java/ojb-0.7.325/buil=
d/test/oj
> b/OJB.properties
>       [ojb] .0     INFO  [main] performance -
>       [ojb] 43032 INFO  [main] performance - inserting 10000 Objects: 4=
2982 msec
>=20
>       [ojb] 94686 INFO  [main] performance - updating 10000 Objects: 51=
614 msec
>       [ojb] 118440 INFO  [main] performance - querying 10000 Objects: 2=
3724 msec
>=20
>       [ojb] 118731 INFO  [main] performance - querying 10000 Objects: 2=
51 msec
>       [ojb] 124539 INFO  [main] performance - fetching 10000 Objects: 5=
728 msec
>       [ojb] 146230 INFO  [main] performance - deleting 10000 Objects: 2=
1681 msec
>=20
>       [ojb] 146240 INFO  [main] performance -
>       [ojb] 183113 INFO  [main] performance - inserting 10000 Objects: =
36873 mse
> c
>       [ojb] 239294 INFO  [main] performance - updating 10000 Objects: 5=
6141 msec
>=20
>       [ojb] 263068 INFO  [main] performance - querying 10000 Objects: 2=
3764 msec
>=20
>       [ojb] 263309 INFO  [main] performance - querying 10000 Objects: 2=
21 msec
>       [ojb] 271400 INFO  [main] performance - fetching 10000 Objects: 8=
061 msec
>       [ojb] 291709 INFO  [main] performance - deleting 10000 Objects: 2=
0299 msec
>=20
>       [ojb] 291719 INFO  [main] performance -
>       [ojb] 334301 INFO  [main] performance - inserting 10000 Objects: =
42562 mse
> c
>       [ojb] 387477 INFO  [main] performance - updating 10000 Objects: 5=
3146 msec
>=20
>       [ojb] 410340 INFO  [main] performance - querying 10000 Objects: 2=
2853 msec
>=20
>       [ojb] 410590 INFO  [main] performance - querying 10000 Objects: 2=
40 msec
>       [ojb] 418402 INFO  [main] performance - fetching 10000 Objects: 7=
802 msec
>       [ojb] 438801 INFO  [main] performance - deleting 10000 Objects: 2=
0389 msec
>=20
>       [ojb]
>       [ojb] Time: 443.167
>       [ojb]
>       [ojb] OK (1 tests)
>       [ojb]
>      [jdbc] [BOOT] INFO: OJB.properties: file:/C:/Java/ojb-0.7.325/buil=
d/test/oj
> b/OJB.properties
>      [jdbc] .0     INFO  [main] performance -
>      [jdbc] 127333 INFO  [main] performance - inserting 10000 Objects: =
17976 mse
> c
>      [jdbc] 157586 INFO  [main] performance - updating 10000 Objects: 3=
0213 msec
>=20
>      [jdbc] 173269 INFO  [main] performance - querying 10000 Objects: 1=
5653 msec
>=20
>      [jdbc] 187710 INFO  [main] performance - querying 10000 Objects: 1=
4381 msec
>=20
>      [jdbc] 189062 INFO  [main] performance - fetching 10000 Objects: 1=
272 msec
>      [jdbc] 198876 INFO  [main] performance - deleting 10000 Objects: 9=
804 msec
>      [jdbc] 198886 INFO  [main] performance -
>      [jdbc] 217032 INFO  [main] performance - inserting 10000 Objects: =
18096 mse
> c
>      [jdbc] 244551 INFO  [main] performance - updating 10000 Objects: 2=
7469 msec
>=20
>      [jdbc] 259052 INFO  [main] performance - querying 10000 Objects: 1=
4480 msec
>=20
>      [jdbc] 273373 INFO  [main] performance - querying 10000 Objects: 1=
4301 msec
>=20
>      [jdbc] 274124 INFO  [main] performance - fetching 10000 Objects: 7=
41 msec
>      [jdbc] 283978 INFO  [main] performance - deleting 10000 Objects: 9=
844 msec
>      [jdbc] 283988 INFO  [main] performance -
>      [jdbc] 302495 INFO  [main] performance - inserting 10000 Objects: =
18507 mse
> c
>      [jdbc] 332858 INFO  [main] performance - updating 10000 Objects: 3=
0333 msec
>=20
>      [jdbc] 348231 INFO  [main] performance - querying 10000 Objects: 1=
5363 msec
>=20
>      [jdbc] 363563 INFO  [main] performance - querying 10000 Objects: 1=
5322 msec
>=20
>      [jdbc] 365335 INFO  [main] performance - fetching 10000 Objects: 1=
732 msec
>      [jdbc] 374789 INFO  [main] performance - deleting 10000 Objects: 9=
424 msec
>      [jdbc]
>      [jdbc] Time: 378.224
>      [jdbc]
>      [jdbc] OK (1 tests)
>      [jdbc]
>=20
> BUILD SUCCESSFUL
>=20
> Total time: 14 minutes 7 seconds
> --------------------------------------------------
>=20
>=20
>=20
>=20
> I'm really confused here, how can I get this slow performance, not in o=
ne, but in two differente computers, when Thomas says OJB + HSQL should p=
erform like this:
>=20
>       [ojb] Time: 17.435
>      [jdbc] Time: 12.065
>=20
>=20
> PLEASE give me a hand here, post your performance results, with OJB + H=
SQL, and then with OJB + MySQL.
> I really need to make the system fast, or else I'll have to code everyt=
hing again, using JDBC... a nightmare.
>=20

As I said before: Even your native JDBC results are very bad! Maybe=20
there are some (not OJB related) problems on your machines. (E.G. There=20
had been a Anti-Virus Software in my company that brought several=20
machines down, etc. etc.)

Mabye you don't have enough RAM, too much other processes running or...

> Does anybody have a clue here? I thought that I had a mysql JDBC driver=
 problem, but looks like the HSQL results are also slow! Does anybody hav=
e any idea of what can I be doing wrong???
>=20

Agreed. This really looks desolate!

Thomas

> Thanks in advance,
>=20
>=20
> Ricardo Arguello
>=20
>=20
>=20
>=20
> _______________________________________________
> Objectbridge-developers mailing list
> Obj...@li...
> https://lists.sourceforge.net/lists/listinfo/objectbridge-developers
>=20
>=20
>=20
>=20