Test Environment: Database Server: 2.4G P4 CPU, 2G Memory, Windows Advanced Server 2000, SQL Server 2000Web Server: 2.4G P4 CPU, 1G Memory, Windows Advanced Server 2000, IIS ASP.NET 1.1 Network Bandwidth: 100M Database Table : 20 fields, 24885 records, data size is 5.38M client: 1, a notebook: Windows XP IE6, PIII 500CPU, 448M memory 2, access directly on the WE server
Introduction to the test program: 1, the components used: SqlConnection, SqlCommand, SqlDataReader, DataSet, DataGrid2, SqlDataReader read data from the database via SqlCommand, and write data into the DataSet, then bind to DataGrid. 3. Time point: Set a timepoint point T1 before the SqlDataReader read the data, set a timepoint T2 after SqlDataReader and the data is written to the DataSet, and a timepoint point T3 is set after the DataGrid is databIND (). Set the data in the browser in the DataGrid set a timepoint T4.
Test Results: 1, T1 and T2 The time interval is 1 seconds 2, and the time interval between T2 and T3 is 4 seconds 3, and the time interval between T3 and T4 is very different from the two client access times. Direct access on the WE server, this time interval is about 35-40 seconds, accessed on the notebook, this time interval is two minutes. 4, the memory consumption of IE is so large, on the web server of the Windows 2000 system, after access, IE takes up 400 M memory. On the Notebook of the Windwos XP system, IE occupies more than 200 M memory. 5. I wrote another functional WinForm program, only two seconds from T1 to T4.
