August 2008 Entries

Performance -- DataTable.Select vs Dictionary

Kathleen Dollard made an offhand comment a while back that List(Of T) should be a better option than DataTable in many cases. Today, I finally got around to benchmarking some various flavors of DataTable vs. Dictionary. Let me begin by stating the caveat that my benchmarks cover only the scenario where there is a known primary key that is the term used for DataTable.Select. I also only concerned myself with name/value pairs -- at the moment I'm really looking at a "lookup table" sort of scenario. ...