huge stopwatch

In. before Net Framework 2.0, array representation can be represented by array and arraylist of collection classes. After 2.0 ,. NET introduces the generic concept list 2.0 the intention of introducing generic models is to reduce the performance consumption caused by packing and unpacking of types. For example; Private void compareto { .... } The list Today, we mainly discuss what kind of performance is higher when the type is determined. arraylist does not need to be considered. It must be

1. Use the stopwatch class (system. Diagnostics. stopwatch) The stopwatch instance can measure the running time at one interval or the total running time at multiple intervals. In a typical stopwatch solution, call the start method, call the stop method, and use the elapsed attribute to check the running time. The

int count = 1000000; // Number of inserted itemsStatic void Main (string [] args){// Long commonInsertRunTime = CommonInsert ();// Console. WriteLine (string. Format ("the time used to insert {1} pieces of data in normal mode is {0} millisecond", commonInsertRunTime, count ));Long sqlBulkCopyInsertRunTime = SqlBulkCopyInsert ();Console. WriteLine (string. Format ("the time used to insert {1} pieces of data using SqlBulkCopy is {0} millisecond", sqlBulkCopyInsertRunTime, count ));Long TVPInsertR

;Using System. Diagnostics;Using System. Data;Using System. Data. SqlClient;Using com. DataAccess;Namespace ConsoleAppInsertTest{Class Program{Static string connectionString = SqlHelper. ConnectionStringLocalTransaction; // database connection stringStatic int count = 1000000; // Number of inserted itemsStatic void Main (string [] args){// Long commonInsertRunTime = CommonInsert ();// Console. WriteLine (string. Format ("the time used to insert {1} pieces of data in normal mode is {0} millisecon

= Sqlhelper.connectionstringlocaltransaction; Database connection stringstatic int count = 1000000; Number of bars insertedstatic void Main (string[] args){Long commoninsertruntime = Commoninsert ();Console.WriteLine (String. Format (the time spent in the normal way to insert {1} data is {0} milliseconds, Commoninsertruntime, count));Long sqlbulkcopyinsertruntime = Sqlbulkcopyinsert ();Console.WriteLine (String. Format ("The time used to insert {1} data using SqlBulkCopy is {0} milliseconds", S

comments. Copy Code code as follows: Using System; Using System.Diagnostics; Using System.Data; Using System.Data.SqlClient; Using COM. DataAccess; Namespace Consoleappinserttest { Class Program { static string connectionString = Sqlhelper.connectionstringlocaltransaction; Database connection string static int count = 1000000; Number of bars inserted static void Main (string[] args) { Long commoninsertruntime = Commoninsert (); Console.WriteLine (String. Format (the ti

Program{Static string connectionstring = sqlhelper. connectionstringlocaltransaction; // database connection stringStatic int COUNT = 1000000; // Number of inserted itemsStatic void main (string [] ARGs){// Long commoninsertruntime = commoninsert ();// Console. writeline (string. Format ("the time used to insert {1} pieces of data in normal mode is {0} millisecond", commoninsertruntime, count ));Long sqlbulkcopyinsertruntime = sqlbulkcopyinsert ();Console. writeline (string. Format ("the time u

I talked with others about the performance of linq yesterday. I feel that the performance of linq is not good, but in fact it is still outstanding in terms of performance, except for the ability to write data to SQL, the following is a simple performance test comparison code. Here I will explain that the execution speed of the Code cannot be tested using datetime. I am still a little white, just starting with datetime, the results showed that the performance of the linq service was not good, but

I talked with others about the performance of LINQ yesterday. I feel that the performance of LINQ is not good, but in fact it is still outstanding in terms of performance, except for the ability to write data to SQL, the following is a simple performance test comparison code. Here I will explain that the execution speed of the Code cannot be tested using datetime. I am still a little white, just starting with datetime, the results showed that the performance of the LINQ service was not good, but

In a project, it is often necessary to log records of execution performance (time spent) of some methods, which are implemented in two ways.StopWatchUsing the Stopwatch class to measure time is very simple. Like the stopwatch in real life, this class of objects can start, stop, zero (reset) operations on the counter, but it is much more accurate than the average stopwat