Cache vs Session,Application state for datagrid - DOTNET

Hello, Marisha!

M> I have a question,what is the best way to preserve dataset in web
M> application:
M> Cache object,Session or Application state.
??>> From perfomance,scalability point of view?
M> Any ideas?

I assume that dataset is valid for secial session? if so you can use Session.
If dataset is application wide you can store it in some static property, or static suctom cache object.(smth like static hashtable)

--
Regards, Vadym Stetsyak
www: http://vadmyst.blogspot.com

Hi Vadym,
Thanks fro you reply,
I used session and cache object for storing dataset that fills datagrid
and both give me out of memory exception when i try to edit some row in
a datagrid that has 900+ rows.
Is 900+ is to much to handle for the grid?

Hello, Marisha!

M> Hi Vadym,
M> Thanks fro you reply,
M> I used session and cache object for storing dataset that fills datagrid
M> and both give me out of memory exception when i try to edit some row in
M> a datagrid that has 900+ rows.
M> Is 900+ is to much to handle for the grid?

Hard to tell, it depends also on column number...

OTOH why do you have to store the dataset of such size?

--
Regards, Vadym Stetsyak
www: http://vadmyst.blogspot.com

I have about 15 columns.
On average I have about 30-50 rows in dataset.
It's very rarely that I have so bulky data,but if I have it,I need to
be able to handle it..