Skip to content

Instantly share code, notes, and snippets.

@rcollette
Created August 16, 2013 19:24
Show Gist options
  • Save rcollette/6252767 to your computer and use it in GitHub Desktop.
Save rcollette/6252767 to your computer and use it in GitHub Desktop.
Results of IDbCommand cancel and no cancel when disposing before all records have been read.
<?xml version="1.0" encoding="utf-8"?>
<PerformanceReport>
<CallTreeSummary>
<CallTree Level="0" FunctionName="DataReaderDisposeCancelTest.exe" InclusiveElapsedTime="22,386.00" ExclusiveElapsedTime="0.00" InclusiveApplicationTime="0.51" ExclusiveApplicationTime="0.00" InclusiveElapsedTimePercent="100.00" ExclusiveElapsedTimePercent="0.00" InclusiveApplicationTimePercent="100.00" ExclusiveApplicationTimePercent="0.00" NumCalls="0" ModuleName="" />
<CallTree Level="1" FunctionName="DataReaderDisposeCancelTest.Program.Main(string[])" InclusiveElapsedTime="22,386.00" ExclusiveElapsedTime="0.51" InclusiveApplicationTime="0.51" ExclusiveApplicationTime="0.00" InclusiveElapsedTimePercent="100.00" ExclusiveElapsedTimePercent="0.00" InclusiveApplicationTimePercent="100.00" ExclusiveApplicationTimePercent="0.35" NumCalls="1" ModuleName="DataReaderDisposeCancelTest.exe" />
<CallTree Level="2" FunctionName="DataReaderDisposeCancelTest.Program.NoCancelTest(class System.Data.IDbCommand)" InclusiveElapsedTime="18,612.14" ExclusiveElapsedTime="0.03" InclusiveApplicationTime="0.26" ExclusiveApplicationTime="0.03" InclusiveElapsedTimePercent="83.14" ExclusiveElapsedTimePercent="0.00" InclusiveApplicationTimePercent="50.45" ExclusiveApplicationTimePercent="6.70" NumCalls="1" ModuleName="DataReaderDisposeCancelTest.exe" />
<CallTree Level="3" FunctionName="System.IDisposable.Dispose()" InclusiveElapsedTime="17,573.38" ExclusiveElapsedTime="17,573.38" InclusiveApplicationTime="0.00" ExclusiveApplicationTime="0.00" InclusiveElapsedTimePercent="78.50" ExclusiveElapsedTimePercent="78.50" InclusiveApplicationTimePercent="0.00" ExclusiveApplicationTimePercent="0.00" NumCalls="50" ModuleName="mscorlib.dll" />
<CallTree Level="3" FunctionName="System.Data.IDbCommand.ExecuteReader()" InclusiveElapsedTime="1,038.51" ExclusiveElapsedTime="1,038.51" InclusiveApplicationTime="0.00" ExclusiveApplicationTime="0.00" InclusiveElapsedTimePercent="4.64" ExclusiveElapsedTimePercent="4.64" InclusiveApplicationTimePercent="0.00" ExclusiveApplicationTimePercent="0.00" NumCalls="50" ModuleName="System.Data.dll" />
<CallTree Level="3" FunctionName="System.Data.IDataRecord.get_Item(int32)" InclusiveElapsedTime="0.13" ExclusiveElapsedTime="0.13" InclusiveApplicationTime="0.13" ExclusiveApplicationTime="0.13" InclusiveElapsedTimePercent="0.00" ExclusiveElapsedTimePercent="0.00" InclusiveApplicationTimePercent="25.03" ExclusiveApplicationTimePercent="25.03" NumCalls="50" ModuleName="System.Data.dll" />
<CallTree Level="3" FunctionName="System.Data.IDataReader.Read()" InclusiveElapsedTime="0.10" ExclusiveElapsedTime="0.10" InclusiveApplicationTime="0.10" ExclusiveApplicationTime="0.10" InclusiveElapsedTimePercent="0.00" ExclusiveElapsedTimePercent="0.00" InclusiveApplicationTimePercent="18.73" ExclusiveApplicationTimePercent="18.73" NumCalls="50" ModuleName="System.Data.dll" />
<CallTree Level="2" FunctionName="DataReaderDisposeCancelTest.Program.CancelTest(class System.Data.IDbCommand)" InclusiveElapsedTime="2,832.95" ExclusiveElapsedTime="0.09" InclusiveApplicationTime="0.25" ExclusiveApplicationTime="0.03" InclusiveElapsedTimePercent="12.65" ExclusiveElapsedTimePercent="0.00" InclusiveApplicationTimePercent="49.19" ExclusiveApplicationTimePercent="5.65" NumCalls="1" ModuleName="DataReaderDisposeCancelTest.exe" />
<CallTree Level="3" FunctionName="System.IDisposable.Dispose()" InclusiveElapsedTime="1,722.08" ExclusiveElapsedTime="1,722.08" InclusiveApplicationTime="0.00" ExclusiveApplicationTime="0.00" InclusiveElapsedTimePercent="7.69" ExclusiveElapsedTimePercent="7.69" InclusiveApplicationTimePercent="0.00" ExclusiveApplicationTimePercent="0.00" NumCalls="50" ModuleName="mscorlib.dll" />
<CallTree Level="3" FunctionName="System.Data.IDbCommand.ExecuteReader()" InclusiveElapsedTime="1,100.33" ExclusiveElapsedTime="1,100.33" InclusiveApplicationTime="0.00" ExclusiveApplicationTime="0.00" InclusiveElapsedTimePercent="4.92" ExclusiveElapsedTimePercent="4.92" InclusiveApplicationTimePercent="0.00" ExclusiveApplicationTimePercent="0.00" NumCalls="50" ModuleName="System.Data.dll" />
<CallTree Level="3" FunctionName="System.Data.IDataRecord.get_Item(int32)" InclusiveElapsedTime="4.35" ExclusiveElapsedTime="4.35" InclusiveApplicationTime="0.13" ExclusiveApplicationTime="0.13" InclusiveElapsedTimePercent="0.02" ExclusiveElapsedTimePercent="0.02" InclusiveApplicationTimePercent="24.56" ExclusiveApplicationTimePercent="24.56" NumCalls="50" ModuleName="System.Data.dll" />
<CallTree Level="3" FunctionName="System.Data.IDbCommand.Cancel()" InclusiveElapsedTime="3.88" ExclusiveElapsedTime="3.88" InclusiveApplicationTime="0.00" ExclusiveApplicationTime="0.00" InclusiveElapsedTimePercent="0.02" ExclusiveElapsedTimePercent="0.02" InclusiveApplicationTimePercent="0.00" ExclusiveApplicationTimePercent="0.00" NumCalls="50" ModuleName="System.Data.dll" />
<CallTree Level="3" FunctionName="System.Data.IDataReader.Read()" InclusiveElapsedTime="2.22" ExclusiveElapsedTime="2.22" InclusiveApplicationTime="0.10" ExclusiveApplicationTime="0.10" InclusiveElapsedTimePercent="0.01" ExclusiveElapsedTimePercent="0.01" InclusiveApplicationTimePercent="18.98" ExclusiveApplicationTimePercent="18.98" NumCalls="50" ModuleName="System.Data.dll" />
<CallTree Level="2" FunctionName="System.Data.Common.DbConnection.Open()" InclusiveElapsedTime="361.85" ExclusiveElapsedTime="361.85" InclusiveApplicationTime="0.00" ExclusiveApplicationTime="0.00" InclusiveElapsedTimePercent="1.62" ExclusiveElapsedTimePercent="1.62" InclusiveApplicationTimePercent="0.00" ExclusiveApplicationTimePercent="0.00" NumCalls="1" ModuleName="System.Data.dll" />
<CallTree Level="2" FunctionName="System.Configuration.ConfigurationManager.get_ConnectionStrings()" InclusiveElapsedTime="310.23" ExclusiveElapsedTime="310.23" InclusiveApplicationTime="0.00" ExclusiveApplicationTime="0.00" InclusiveElapsedTimePercent="1.39" ExclusiveElapsedTimePercent="1.39" InclusiveApplicationTimePercent="0.00" ExclusiveApplicationTimePercent="0.00" NumCalls="1" ModuleName="System.Configuration.dll" />
<CallTree Level="2" FunctionName="System.Data.Common.DbProviderFactories.GetFactory(string)" InclusiveElapsedTime="129.70" ExclusiveElapsedTime="129.70" InclusiveApplicationTime="0.00" ExclusiveApplicationTime="0.00" InclusiveElapsedTimePercent="0.58" ExclusiveElapsedTimePercent="0.58" InclusiveApplicationTimePercent="0.00" ExclusiveApplicationTimePercent="0.00" NumCalls="1" ModuleName="System.Data.dll" />
<CallTree Level="2" FunctionName="System.Data.Common.DbProviderFactory.CreateConnection()" InclusiveElapsedTime="107.36" ExclusiveElapsedTime="107.36" InclusiveApplicationTime="0.00" ExclusiveApplicationTime="0.00" InclusiveElapsedTimePercent="0.48" ExclusiveElapsedTimePercent="0.48" InclusiveApplicationTimePercent="0.00" ExclusiveApplicationTimePercent="0.00" NumCalls="1" ModuleName="System.Data.dll" />
<CallTree Level="2" FunctionName="System.Data.Common.DbConnection.set_ConnectionString(string)" InclusiveElapsedTime="23.15" ExclusiveElapsedTime="23.15" InclusiveApplicationTime="0.00" ExclusiveApplicationTime="0.00" InclusiveElapsedTimePercent="0.10" ExclusiveElapsedTimePercent="0.10" InclusiveApplicationTimePercent="0.00" ExclusiveApplicationTimePercent="0.00" NumCalls="1" ModuleName="System.Data.dll" />
<CallTree Level="2" FunctionName="System.IDisposable.Dispose()" InclusiveElapsedTime="5.81" ExclusiveElapsedTime="5.81" InclusiveApplicationTime="0.00" ExclusiveApplicationTime="0.00" InclusiveElapsedTimePercent="0.03" ExclusiveElapsedTimePercent="0.03" InclusiveApplicationTimePercent="0.00" ExclusiveApplicationTimePercent="0.00" NumCalls="1" ModuleName="mscorlib.dll" />
<CallTree Level="2" FunctionName="System.Data.Common.DbConnection.CreateCommand()" InclusiveElapsedTime="1.31" ExclusiveElapsedTime="1.31" InclusiveApplicationTime="0.00" ExclusiveApplicationTime="0.00" InclusiveElapsedTimePercent="0.01" ExclusiveElapsedTimePercent="0.01" InclusiveApplicationTimePercent="0.00" ExclusiveApplicationTimePercent="0.00" NumCalls="1" ModuleName="System.Data.dll" />
<CallTree Level="2" FunctionName="System.Data.Common.DbCommand.set_CommandText(string)" InclusiveElapsedTime="0.60" ExclusiveElapsedTime="0.60" InclusiveApplicationTime="0.00" ExclusiveApplicationTime="0.00" InclusiveElapsedTimePercent="0.00" ExclusiveElapsedTimePercent="0.00" InclusiveApplicationTimePercent="0.00" ExclusiveApplicationTimePercent="0.00" NumCalls="1" ModuleName="System.Data.dll" />
<CallTree Level="2" FunctionName="System.Configuration.ConnectionStringSettingsCollection.get_Item(string)" InclusiveElapsedTime="0.27" ExclusiveElapsedTime="0.27" InclusiveApplicationTime="0.00" ExclusiveApplicationTime="0.00" InclusiveElapsedTimePercent="0.00" ExclusiveElapsedTimePercent="0.00" InclusiveApplicationTimePercent="0.00" ExclusiveApplicationTimePercent="0.00" NumCalls="1" ModuleName="System.Configuration.dll" />
<CallTree Level="2" FunctionName="System.Configuration.ConnectionStringSettings.get_ConnectionString()" InclusiveElapsedTime="0.07" ExclusiveElapsedTime="0.07" InclusiveApplicationTime="0.00" ExclusiveApplicationTime="0.00" InclusiveElapsedTimePercent="0.00" ExclusiveElapsedTimePercent="0.00" InclusiveApplicationTimePercent="0.00" ExclusiveApplicationTimePercent="0.00" NumCalls="1" ModuleName="System.Configuration.dll" />
<CallTree Level="2" FunctionName="System.Configuration.ConnectionStringSettings.get_ProviderName()" InclusiveElapsedTime="0.05" ExclusiveElapsedTime="0.05" InclusiveApplicationTime="0.00" ExclusiveApplicationTime="0.00" InclusiveElapsedTimePercent="0.00" ExclusiveElapsedTimePercent="0.00" InclusiveApplicationTimePercent="0.00" ExclusiveApplicationTimePercent="0.00" NumCalls="1" ModuleName="System.Configuration.dll" />
</CallTreeSummary>
</PerformanceReport>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment