Hibernate Community • View topic - performance of "identity" generator class

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

performance of "identity" generator class

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

jr76

Post subject: performance of "identity" generator class

Posted: Wed Jan 17, 2007 2:13 pm

Beginner

Joined: Thu Nov 02, 2006 5:11 pm
Posts: 32
Location: Toronto

Can anyone comment on the insert performance of the "identity" generator class with MS SQL Server? Does the need for the extra "select SCOPE_IDENTITY()" actually require a separate trip to the database, or is it batched together with the Insert statement?

Thanks,
jon

Top

grennis

Post subject:

Posted: Wed Jan 17, 2007 2:26 pm

Senior

Joined: Sat Mar 25, 2006 9:16 am
Posts: 150

Its batched together. This is pretty standard in any SQL server database communication... not sure why it would be considered somehow worse under NHibernate than anything else.

Top

jr76

Post subject:

Posted: Wed Jan 17, 2007 3:17 pm

Beginner

Joined: Thu Nov 02, 2006 5:11 pm
Posts: 32
Location: Toronto

grennis wrote:

Its batched together. This is pretty standard in any SQL server database communication... not sure why it would be considered somehow worse under NHibernate than anything else.

Thanks grennis.

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum