Date: 10/28/04 (C Sharp)    Keywords: database, web

hi all

i have a webservice that returns multiple datasets of different tables that i need to merge/sync with a destination database that is accessible through a middle tier component that i wrote. unfortunately, i'm restricted to the use of ado.net and datasets due to the nature of the webservice in question. i'm working with moderately high number of records (largest table is around 5k rows) that i need to insert into the destination database, and i'm using the dataset.merge method with a customized insertcommand (as i need to wrap identity insert on around it and also the table columns won't be determined till run time) passed to the dataset, and it's pretty slow. i think part of the slowness comes from having to figure out the column schema of the varying tables, and also the fact that ado.net is not particularly a useful tool for data transfer. just wanted to know if anyone has any pointers/ideas as to how to optimize this routine? thanks in advance for your input.

Source: http://www.livejournal.com/community/csharp/19919.html