ranzlee / NHibernate.Extensions

Helper libs for NHibernate
28 stars 15 forks source link

NHibernate.Glimpse always records a zero duration in timeline #5

Open kellystuard opened 11 years ago

kellystuard commented 11 years ago

Looking in https://github.com/ranzlee/NHibernate.Extensions/blob/master/NHibernate.Glimpse/InternalLoggers/SqlInternalLogger.cs

It seems that point.Duration will always be zero and the StartTime will always be the end time of the sql statement that was run.

When I run pages with long queries, Glimpse always shows the queries as taking 0ms.

ranzlee commented 11 years ago

Hi Kelly,

You are correct. Unfortunately, the NH logging infrastructure doesn’t lend itself to acquiring accurate execution durations for the Glimpse timeline. The actual execution durations do show in the log data in the NH tab. I do plan on looking into parsing the data out for the timeline or switching to the Glimpse ADO hooks (moving off the NH logging infrastructure).

Thanks,

Randy

From: Kelly Stuard Sent: ‎Friday‎, ‎September‎ ‎20‎, ‎2013 ‎2‎:‎04‎ ‎PM To: ranzlee/NHibernate.Extensions

Looking in https://github.com/ranzlee/NHibernate.Extensions/blob/master/NHibernate.Glimpse/InternalLoggers/SqlInternalLogger.cs

It seems that point.Duration will always be zero and the StartTime will always be the end time of the sql statement that was run.

When I run pages with long queries, Glimpse always shows the queries as taking 0ms.

— Reply to this email directly or view it on GitHub.