SqlCeResultSet vs. SqlCeDataReader performance

[dwok]

Does anyone have any idea how the new SqlCeResultSet compares to the
SqlCeDataReader in performance? I have been frustrated with the
in-ability to databind the SqlCeDataReader and I am hoping the new
SqlCeResultSet will provide similar performance. Thanks.

-DWOK

 

[Ginny Caughey [MVP]]

DWOK,

Since SqlCeResultSet is a data reader, the performance should be roughtly
comparable, and that's what I'm seeing although I haven't done any
benchmarks. Certainly SqlCeResultSet is quite a bit faster than using the
data adapter to fill a dataset. I'd suggest just trying it.

 

[dwok]

Thanks Ginny,

I will give it a whirl and post back my results.