Performance issue when storing large dataset in Session variable

[None]

Hi,

I have developed webshop application using asp.net 1.1. I'm using
DataGrid in one of the pages of my site. During the page load the
DataGrid will be binded by around 7500 products(rows). At the same time
i'm storing the DataSet object in the Session Variable for later
refinement. I'm using StateServer mode for storeing the session values.


But in my server the W3wp.exe is taking 90 - 100 % CPU
Utlilization. Also my pages are loading very slowly. So afterthat even
if i browse some static pages in my site, then the static pages are
also taking much time to load.

I know that session is making problem because of its size. But i
need the DataSet object for later refinement. This i have tested with
only one user. But i dont know what will happen if 1000 of users access
the site.

My Questions are:

1. So How can i store the large DataSet object in session
variable?
2. Is there anyother way to solve this problem instead of
storing it in the session expect in the database?


If anybody knows the solution please let me know.


Thanks and Regards,
Vinothkumar B
(e-mail address removed)

 

[Karl Seguin [MVP]]

Some general thoughts.

Is it possible to leverage the database more? Specifically, can you do your
refinement in a stored procedure? Can you add paging so that not all 7500
rows are needed at once?

Is the data user-specifc? If it isn't, the session isnt' the right place and
you are right, it won't scale well. If it's global to all users of your
side, using the Cache might be better - but I'd still look at ways to make
it less than 7500 rows...

Karl