Wednesday, April 20, 2011

ADO and ADO.Net performance

It is said that ADO.Net performs much better than ADO, but actually I could not find any benchmarks. Well, I did not perform them either but we have recently migrated some of our code from ADO to ADO.Net. It is performing some computation based on data that is in database. There is quite a lot of DB queries and updates. Migration from ADO to ADO.Net has cut the execution time in this part by half. So it was definitely worth doing. The program is running on VB.Net / .Net 4.0 (it is compiled for .Net 4.0).