boxing stopwatch

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

Steps and methods of exercise (1) skillful routines and clear posture The so-called "routine" refers to the entire architecture of Taijiquan. The so-called "posture" refers to the action structure of each type. At the beginning of the school, the primary focus is on the routine proficiency, and the orientation is correct. Pay attention to the posture specification. After a period of practice, the routine has been skilled. At this time, you must focus on the correct posture so that you can genera

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