application-level dataset

  • Thread starter Thread starter Sergei Shelukhin
  • Start date Start date
S

Sergei Shelukhin

Hi :)

I need to store some data in application level dataset. Once a month, a
huge query is performed against a set of big tables and the result is
stored. The dataset is stored in applicaton level variable and is used
to display some report.

However there's a problem, the app might restart (because of the
changes made by developers), IIS might restart and server can sometimes
restart too. I can't requery the data because it will be different by
that time, so I need to maintain the dataset someplace else. It doesn't
change thru the month so I'm safe if it is 3 days old or something.

How do I store it?
 
Hi,

how big the ds is? Have you considered storing it as an XML file
(Dataset.WriteXml)? Is it too big for that?
 
Why not to keep it in a separate database table? In the same database where
the big tables are or in a separate one.

Eliyahu
 
However there's a problem, the app might restart (because of the
changes made by developers), IIS might restart and server can sometimes
restart too. I can't requery the data because it will be different by
that time, so I need to maintain the dataset someplace else. It doesn't
change thru the month so I'm safe if it is 3 days old or something.

How do I store it?
Click to expand...

I would cache the data as an XML file - or even better, write the records
into a summary database table.
 
Back
Top