Friday, April 17, 2009

C# - Performance difference between use of Datatable and use of external database


C# is having Dataset and datatables which can be used much similar to external database (eg. ms access database (.mdb)).

Even when the database is more optmized to handle query for selection and sorting, it is advisable to use built-in Dataset/Datatables.

Because I/O operations between the C#/.net application and the external database will consume significant time which will ultimately reduce the performance/speed of execution.

I can see significant performance difference between these two approaches when we did some performance testing using the code developed based on database and the code using built-in datatables.

But I am not sure whether Dataset will be useful if we need to handle large amount of data.
More Articles...

1 comment:

darichkid said...

Here is a database compatible with .NET, Silverlight, Windows Phone, Mono, Monodroid, and Monotouch:
http://www.kellermansoftware.com/p-43-ninja-net-database-pro.aspx

Search This Blog