Hibernate benchmark, Oracle problems

bimki · **Posted:** Sun May 15, 2005 11:56 am

Hi,

I'm preparing OO7 benchmark http://citeseer.ist.psu.edu/carey94oo.html for Hibernate (and other OR mappers).

I have problems with performance for Oracle. I use standard oracle.jdbc.driver.OracleDriver and performance for MySQL is much better, than for Oracle.

Whitch parameters can I try to change to have better performance for Oracle?

I use Oracle 9i with standard configuration.

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

you can't test oracle (license deny this), but you can test hibernate via jdo

Have you any detail about schema, data (number of rows,column), etc ?

I don't beleive that oracle is slower, execpt if you have big simple table without index

regards

bimki · **Posted:** Sun May 15, 2005 4:22 pm

hi,

I'm a student and I have the license from my University :)

Data structure is simmilar to this : http://www.objectidentity.com/images/oo7jdo.pdf

there is no table without index... I don't belive too.

I've tested it with mySQL and SQL server and I want to have one database more.

Postgres was as slow as Oracle in my test. Perhabs I'll stay with mySQL and SQL server results :)

greetings,

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

read license - you can't test oracle - license deny testing explicit

postgres and oracle are only database with MVC (multiversion control) - it have big preformance
improvement in on-line application (with many small transactions) - it can be reason for your performance down

what query (or ddl is slow) and how much dtaa (rows) have you in tables (for slow query)

bimki · **Posted:** Sun May 15, 2005 6:51 pm

There are some levels in my database (data structure is hierarchical) :

1 level - one record
2nd level - 364
3rd level - 729
4. level 500 records
5 level 10000

Im getting from database explicit one record (elemen level 1) and than through lazy initialization i go down my structure. During my experiment I want to visit every element of level 5.

I dont know how many queries hibernate send to database, but in mySQL it works quite fine.

This experiment shows, that Object databases (i.e. ObjectStore) cannot be compared to RBD.

all my experiment are stricte Objectional and I don't suspect to have super performance :)

Dou You have any other reasons why with postres and Oracle results are worse than for SQL Server and mySQL?

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

bimki,
What is performance results.
Is it hours on oracle, postgresql and seconds on mysql or what ?

I can't analyze document http://www.objectidentity.com/images/oo7jdo.pdf, but I can help
you if you send me query (or like) and table structure

regards