Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ------------------------------------------------------------------------------------------------------------------------------------------------
- |# | Table Rows | Iterations | Measured query | Elapsed Time | Measured query | Elapsed Time |
- ------------------------------------------------------------------------------------------------------------------------------------------------
- |1 | 1000 | 100 | Select,Console.WriteLine | 00:00:10.5507411 | Select | 00:00:00.0024548 |
- ------------------------------------------------------------------------------------------------------------------------------------------------
- |2 | 1000 | 10000 | ToList | 00:00:14.0136524 | -- | 00:00:00.0000521 |
- ------------------------------------------------------------------------------------------------------------------------------------------------
- |2'| 1000 | 10000 | ToList with Count | 00:00:22.6995110 | Count | 00:00:05.4453051 |
- ------------------------------------------------------------------------------------------------------------------------------------------------
- |3 | 1000 | 1000 | ToList, FirstOrDefault | 00:00:01.6237243 | FirstOrDefault | 00:00:00.2924465 |
- ------------------------------------------------------------------------------------------------------------------------------------------------
- |4 | 1000 | 1000 | Include | 00:00:00.0113076 | -- | 00:00:00.0000051 |
- ------------------------------------------------------------------------------------------------------------------------------------------------
- |4'| 1000 | 1000 | Include with Count | 00:00:00.6547914 | Count | 00:00:00.7667228 |
- ------------------------------------------------------------------------------------------------------------------------------------------------
- |5 | 1000 | 1000 | Include, ToList | 00:00:20.9042604 | ToList | 00:00:02.6157810 |
- ------------------------------------------------------------------------------------------------------------------------------------------------
- |6 | 1000 | 1000 | Include,FirstOrDefault | 00:00:00.5997641 | FirstOrDefault | 00:00:00.2981418 |
- ------------------------------------------------------------------------------------------------------------------------------------------------
- |7 | 1000 | 1000 | Include, foreach | 00:00:23.6236213 | foreach | 00:00:05.4142968 |
- ------------------------------------------------------------------------------------------------------------------------------------------------
- |8 | 1000 | 1000 | Include, foreach with ToList| 00:00:23.5413336 | foreach with ToList | 00:00:05.6094237 |
- ------------------------------------------------------------------------------------------------------------------------------------------------
- |9 | 1000 | 1000 | Include, foreach with Count | 00:00:23.4696566 | foreach with Count | 00:00:05.3992506 |
- ------------------------------------------------------------------------------------------------------------------------------------------------
- |10| 1000 | 1000 | Include, foreach with Where | 00:00:23.2747433 | foreach with Where | 00:00:05.3321489 |
- ------------------------------------------------------------------------------------------------------------------------------------------------
- |11| 1000 | 1000 | Where,ToList | 00:00:03.2379461 | ToList,Where | 00:00:02.6889438 |
- ------------------------------------------------------------------------------------------------------------------------------------------------
- |12| 1000 | 1000 | Where,Select,ToList | 00:00:02.2404855 | ToList,Where,Select | 00:00:02.8731791 |
- ------------------------------------------------------------------------------------------------------------------------------------------------
- |13| 1000 | 100 | Include, Console.WriteLine | 00:00:29.3585625 | Console.writeLine | 00:00:31.0927040 |
- ------------------------------------------------------------------------------------------------------------------------------------------------
- |14| 1000 | 100 | Select, Console.WriteLine | 00:00:29.0119321 | Console.writeLine | 00:00:31.1226552 |
- ------------------------------------------------------------------------------------------------------------------------------------------------
- |15| 1000 | 1000 | Select,OrderBy,ToList | 00:00:05.0935053 | ToList,Select,OrderBy | 00:00:02.6217577 |
- ------------------------------------------------------------------------------------------------------------------------------------------------
- |16| 1000 | 100 | Select,OrderBy,ToList,Print | 00:00:26.6191915 | ToList,Select,OrderBy,Print | 00:00:26.3339734 |
- ------------------------------------------------------------------------------------------------------------------------------------------------
- |17| 1000 | 1000 | Select,OrderBy,ToList | 00:00:05.1860684 |Native Select,OrderBy,ToList | 00:00:05.1629055 |
- ------------------------------------------------------------------------------------------------------------------------------------------------s
- |18| 1000 | 100 |Select,OrderBy,ToList,Print | 00:00:27.0050372 |Native same query,Print | 00:00:26.4543431 |
- ------------------------------------------------------------------------------------------------------------------------------------------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement