dotTrace from Jetbrains and ANTS Profiler from Red Gate seem
to be resonable priced products. I believe both have trail
versions.
The IBatisNet.DataMapper.Test.NUnit.SqlMapTests.Perf
namespace has tests which compare a SqlMapper to normal
ADO.Net. The recent IL enchancements for getting/setting
values helped out a lot. I think that feature is disabled by
default (add useReflectionOptimizer="true" to your
settings to turn it on).
----- Original Message ----
From: Michael Schall <mike.schall gmail.com>
To: user-csibatis.apache.org
Sent: Thursday, October 26, 2006 12:46:15 PM
Subject: Profiling .Net code
We are running into some performance issues in our
applications using iBatis. Looking at a log4net rolling
file, times from start to finish of select statements can
vary from 15ms to 400+ms for the same call with a sql trace
saying that the sp has 0 duration. I am looking for a
profiling tool that can help us pin point where this time is
being spent. I have downloaded nprof, but it is not the
easiest to use, and there are no docs helping me out.
What are people out there using for a profiling tool? What
have you tried and liked / not liked?
Thanks.
Mike
|