How to handle multiple data sources in .NET

  • Thread starter Thread starter Dinesh
  • Start date Start date
D

Dinesh

Hi,
my existing web application(vb,asp) takes data from
diff sources and populates a sql server which is in turn
used as the data source for the application.

this population of data happens by a nightly process(once
in a day) .

now the requirement is that we need the real data all of
the times . now if i use merging of Data Sets into single
data set. how the Application should handle such big chunk
of data(say in GBs) . what is the optimal solution for
this in .NET ?

ur response will be highly appreciated
 
No, the Solution requires that the SQL Server should be
eliminated and the Application should directly fetch data
from diff sources,keep it in temp store (Data Set) process
it and then display . but how can we justify this approach
as the data is large, what abt memory? Is there any way
out here ? plz suggest.
thanx & regards,
Dinesh.
 
Stick with SQL server.
If you have that much data it's going to kill your machine
putting it in a dataset.
 
Back
Top