469,331 Members | 3,015 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,331 developers. It's quick & easy.

Performance issue when storing large dataset in Session variable

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
bv*****@tvsinfotech.com

Oct 24 '06 #1
1 2632
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

--
http://www.openmymind.net/
http://www.fuelindustries.com/
"None" <vi********@gmail.comwrote in message
news:11*********************@h48g2000cwc.googlegro ups.com...
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
bv*****@tvsinfotech.com

Oct 24 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Robin Edgar Hansen | last post: by
4 posts views Thread by mechweb | last post: by
10 posts views Thread by shsandeep | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Purva khokhar | last post: by
1 post views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.