Hibernate version:
NHibernate v1.0.2

Name and version of the database you are using:
MySql 5.0

Other:
ASP.NET v1.1 / C#


This is a very strange one - I have an object called a request, and I need to list those requests 10 or 20 per page for reporting purposes.

One day I realized it was taking a long time to return 10 requests (no child objects, about 30 something fields that are all primary types or Enums. I thought "Well that is strange?!" - it would take between 3 and for 4 seconds to load and display 10 requests. The database is basically empty (talking less than 100 rows)...

Well to make a long story short, when my request object has 35 member fields all accessed through their property assessors, it takes 3-4-5 seconds to load 10 requests. If I comment out any one of the properties, it basically runs quicker than 1 second each time.

I am about to go sift through the SQL generated - will post it shortly - just curious if anyone has any insight on this...

Thanks!

Greetings,

From what I can tell roughly the same amount of SQL is created - is there some issue with the # of params or something before it has to make two trips? Strange....

Any ideas?

Already tested the code on two seperate computers and I can re-create the same major difference in the the speed on both...

Can you try a test using plain ADO.NET?