not sure what you meant by your first question. can you explain? the time measured by SQL profiler includes just the time of the query. i'll try downloading nhProf and see what it gives me and then report back.
On Apr 20, 4:04 pm, Fabio Maulo <[email protected]> wrote: > the SQL profiler, are giving you your entities graph ? > The time measured by SQL profiler , does include the time of the > visualization of a bunch of values or just the time needed to execute the > query in the server ? > > > > > > On Wed, Apr 20, 2011 at 10:36 AM, sJhonny <[email protected]> wrote: > > Hi, > > I have an entity with a lazy-loading collection. I've noticed that > > loading this collection (~20 records) takes about 30ms (according to > > nHib trace). > > when using SQL server profiler, I see that the statement itself has a > > duration of 0. > > (By the way- this gets worse with larger collections: a few thousand > > records take about 11000ms to load, while the query against the DB > > takes 20ms to complete). > > I've turned on reflection optimization (didn't seem to have any > > effect). > > > It seems to me like this should be very simple; am I missing > > something? am I doing anything wrong? > > Does it really take that long to hydrate the result set? > > > I'm using nH 2.1.2 (with fluent nH) against a sql server 2008 DB. > > thanks in advance > > Jhonny > > > -- > > You received this message because you are subscribed to the Google Groups > > "nhusers" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group at > >http://groups.google.com/group/nhusers?hl=en. > > -- > Fabio Maulo- Hide quoted text - > > - Show quoted text - -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
