one last question

magoicochea · **Joined:** Fri Apr 13, 2007 12:54 pm **Posts:** 8

Is it a good practice or will performance be better if I use a SERIAL datatype as an Id?

What does Hibernate do to generate the Id? Does it do a Select MAX to get the new Id?

damnhandy · **Posted:** Sat Apr 14, 2007 11:13 pm

Quote:

Is it a good practice or will performance be better if I use a SERIAL datatype as an Id?

That would depend on what database you are using. I have used Oracle, MySQL, and PostgreSQL and have never seen anything significant.

Quote:

What does Hibernate do to generate the Id? Does it do a Select MAX to get the new Id?

This all depends on what ID generator you choose along with what database you are using. There are SEVERAL ID generators available in Hibernate:

http://www.hibernate.org/hib_docs/v3/re ... aration-id

Ryan-