Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

Performance

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

rmswalsh

Post subject: Performance

Posted: Thu Jul 26, 2007 9:13 am

Beginner

Joined: Fri May 25, 2007 5:55 am
Posts: 26

Yes, I could. But that is not the question I am asking. I will be profiling mainly hibernate code and I cant optimise that.

The question I am asking is : are there any other ways I can get more performance from this example. Has anyone anything else to add on experiences with performance tuning in similar situations.

This query is taking me 35 seconds or so now. Same as ADO.NET. I am trying to get the retrieval of 100,000 rows down to 10 seconds if I can. Not sure if its possible.

I have tried since to use Enumerable to see if its better, buts its actually much much worse.

I also tried IQuery but its roughly the same performance.

Top

derek.ekins

Post subject:

Posted: Thu Jul 26, 2007 9:58 am

Beginner

Joined: Wed Oct 04, 2006 8:57 am
Posts: 25

Quote:

This query is taking me 35 seconds or so now. Same as ADO.NET. I am trying to get the retrieval of 100,000 rows down to 10 seconds if I can. Not sure if its possible.

NHibernate uses ado.net to get the data so as far as I am aware you will never get it to run faster than ado.net.

Top

Page 1 of 1

[ 2 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