Performance Concerns between DataTable and SqlDataReader to fill Data with FlexGrid

Question

Which one is more faster between DataTable and SqlDataReader while I'm trying to fill Data into FlexGrid with VB.NET?

score 1 · Answer 1 · answered Nov 05 '09 at 11:34

1

SqlDataReader is faster as it is readonly forward only. However DataTable is xml based and is slower.

answered Nov 05 '09 at 11:34

IsmailS

10,797
21
82
134

score 1 · Accepted Answer · answered Nov 05 '09 at 11:35

1

Depends what are you trying to do, if you just need to get x rows then Reader would be faster but if you will manipulate or want to use caching for result set then go for Data collection of any kind.

answered Nov 05 '09 at 11:35

eugeneK

10,750
19
66
101

score 1 · Answer 3 · answered Nov 05 '09 at 11:35

1

SqlDataReader is much faster. It is readonly and you can only forward run on it.

I use readers all the time unless it's an emergency...

answered Nov 05 '09 at 11:35

Faruz

9,909
10
48
66

Performance Concerns between DataTable and SqlDataReader to fill Data with FlexGrid

3 Answers3