1
int t_rowNum = 10000 ;
2
int t_column = 1000 ;
3
Console.WriteLine("测试创建一个{0}行{1}列的表需要多少时间:",t_rowNum,t_column);
4
DataTable dt = new DataTable();
5
DateTime t1 = DateTime.Now ;
6
DataColumn dc ;
7
for( int c= 0 ;c< t_column ; c++ )
8
{
9
dc = new DataColumn("c"+c);
10
11
dt.Columns.Add( dc );
12
13
}
14
DateTime t2 = DateTime.Now ;
15![](/Images/OutliningIndicators/None.gif)
16
Console.WriteLine("列已经创建,耗时:"+(t2-t1).Milliseconds+"毫秒");
17![](/Images/OutliningIndicators/None.gif)
18
DateTime t3=DateTime.Now ;
19
DateTime t4 =DateTime.Now;
20![](/Images/OutliningIndicators/None.gif)
21
DateTime t5=DateTime.Now ;
22
DataRow dr ;
23
for(int r=0;r<t_rowNum;r++)
24
{
25
if ( r == 0 )
26
t3 = DateTime.Now;
27
dr = dt.NewRow();
28
for( int c=0;c<t_column;c++)
29
{
30
dr[c]="hahshisadadaihdiashd"+c+":"+r ;
31
32
}
33
dt.Rows.Add(dr);
34
35
if ( r== 0 )
36
{
37
t4 = DateTime.Now ;
38
Console.WriteLine("正在创建行,预计耗时:"+((t4-t3).Milliseconds*t_rowNum)+"毫秒");
39
}
40
}
41
DateTime t6 =DateTime.Now;
42![](/Images/OutliningIndicators/None.gif)
43
Console.WriteLine("行已经创建,耗时:"+((t6-t5).TotalSeconds)+"秒");
44![](/Images/OutliningIndicators/None.gif)
45
Console.ReadLine();
这个还是要耗用900多M内存~
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/None.gif)
3
![](/Images/OutliningIndicators/None.gif)
4
![](/Images/OutliningIndicators/None.gif)
5
![](/Images/OutliningIndicators/None.gif)
6
![](/Images/OutliningIndicators/None.gif)
7
![](/Images/OutliningIndicators/None.gif)
8
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
9
![](/Images/OutliningIndicators/InBlock.gif)
10
![](/Images/OutliningIndicators/InBlock.gif)
11
![](/Images/OutliningIndicators/InBlock.gif)
12
![](/Images/OutliningIndicators/InBlock.gif)
13
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
14
![](/Images/OutliningIndicators/None.gif)
15
![](/Images/OutliningIndicators/None.gif)
16
![](/Images/OutliningIndicators/None.gif)
17
![](/Images/OutliningIndicators/None.gif)
18
![](/Images/OutliningIndicators/None.gif)
19
![](/Images/OutliningIndicators/None.gif)
20
![](/Images/OutliningIndicators/None.gif)
21
![](/Images/OutliningIndicators/None.gif)
22
![](/Images/OutliningIndicators/None.gif)
23
![](/Images/OutliningIndicators/None.gif)
24
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
25
![](/Images/OutliningIndicators/InBlock.gif)
26
![](/Images/OutliningIndicators/InBlock.gif)
27
![](/Images/OutliningIndicators/InBlock.gif)
28
![](/Images/OutliningIndicators/InBlock.gif)
29
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
30
![](/Images/OutliningIndicators/InBlock.gif)
31
![](/Images/OutliningIndicators/InBlock.gif)
32
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
33
![](/Images/OutliningIndicators/InBlock.gif)
34
![](/Images/OutliningIndicators/InBlock.gif)
35
![](/Images/OutliningIndicators/InBlock.gif)
36
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
37
![](/Images/OutliningIndicators/InBlock.gif)
38
![](/Images/OutliningIndicators/InBlock.gif)
39
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
40
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
41
![](/Images/OutliningIndicators/None.gif)
42
![](/Images/OutliningIndicators/None.gif)
43
![](/Images/OutliningIndicators/None.gif)
44
![](/Images/OutliningIndicators/None.gif)
45
![](/Images/OutliningIndicators/None.gif)