Gambit_NI
Active member
[Resolved] Dataset vs DataReader - has got me thinking
ive just been reading the following thread http://www.vbdotnetforums.com/showthread.php?t=3855 in the Articles of Interest about the performance difference between Datasets & datareaders
this has got me thinking on how i would go about changing the way we currently access our data as alot of our system do have to return large amounts of records and can seem slow sometime
all our systems are mainly just retrieving data and displaying in Grids, Lists etc. so no need to move back n forth thru the dataset
the way we work at the minute is we pass an empty dataset from the form/webpage to the class, the class then passes the empty dataset into the webservice where a stored proc is called, and the dataset filled. the dataset is then passed back to the form.
my question is, is there a better way of doing this??
ive just been reading the following thread http://www.vbdotnetforums.com/showthread.php?t=3855 in the Articles of Interest about the performance difference between Datasets & datareaders
this has got me thinking on how i would go about changing the way we currently access our data as alot of our system do have to return large amounts of records and can seem slow sometime
all our systems are mainly just retrieving data and displaying in Grids, Lists etc. so no need to move back n forth thru the dataset
the way we work at the minute is we pass an empty dataset from the form/webpage to the class, the class then passes the empty dataset into the webservice where a stored proc is called, and the dataset filled. the dataset is then passed back to the form.
my question is, is there a better way of doing this??
Last edited: