DataGridView

by Codewiz51 21. December 2009 12:49

I am not impressed with the speed of the DataGridView control in the following scenerio:

  • Dataset is persisted as XML file.
  • Dataset contains two tables, one relationship and two primary keys.
  • Performance when accessing DataRows in code is very fast.
  • Performance when populating the DataGridView control with 300+ rows and 40 columns of data from a table in the Dataset is abysmal.

We are using XML format to persist data for a variety of customer requirements.  We probably should have used SQL Server mobile or compact edition, but we didn't.

Beware of using the DataGridView until you examine application performance with realistic data.

Tags: , ,

Programming

Disclaimer

This blog represents my personal hobby, observations and views. It does not represent the views of my employer, clients, especially my wife, children, in-laws, clergy, the dog, the cat or my daughter's horse. In fact, I am not even sure it represents my views when I take the time to reread postings.  So, take most of what I say with a grain of salt.

© Copyright 2008-2014