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 -- 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.
