datarow filter

[chronics]

Hi

I just have a simple question. is it better to use a dataview with a rowfilter or to use linq as a datasource for a datagridview. When i say better i mean performance wise as im not bothered about syntax.

Thanks

 

[jmeckley]

that depends on the amount of data and how you are using it.
make it work
make it maintainable
make it fast
in that order.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[chronics]

The queries arent very complex,there be a maximum of a few thousand rows. Both methods will work and are maintainable but the result of the linq query would then have to use the AsDataView() method anyway which is why im wondering if that may cause a performance drop.

 

[jmeckley]

first get it working, then check the preformance levels using a tool like dot net trace. As a general rule the bottlenecks occur when memory needs to access IO. (files, database, serialization, etc)

Jason Meckley
Programmer
Specialty Bakers, Inc.