473,594 Members | 2,613 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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*****@tvsinfo tech.com

Oct 24 '06 #1
1 2814
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********@gma il.comwrote in message
news:11******** *************@h 48g2000cwc.goog legroups.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*****@tvsinfo tech.com

Oct 24 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1362
by: Robin Edgar Hansen | last post by:
Hi! I'd like to store an object in a session variable and thus keep it 'alive' for the entire session. More precisely I wanted to do this (possibly in Application_OnStart()): import telnetlib cli = telnetlib.Telnet("localhost",9999) Session.SetValue("cli",cli)
3
5214
by: Paul Mateer | last post by:
Hi, I have been running some queries against a table in a my database and have noted an odd (at least it seems odd to me) performance issue. The table has approximately 5 million rows and includes the following columns: DocID (INTEGER, PRIMARY KEY, CLUSTERED) IsRecord (INTEGER, NONCLUSTERED)
4
1710
by: Benjamin Joldersma | last post by:
Hi all, If I have a expensive public property that exposes a collection, say via a call to a database: public ArrayList Complex { get { //expensive call to db
1
1349
by: bob | last post by:
Currently i'm writing some low level communication modules in C++ and is thinking of putting it into a library so that it can be used in C#. My concern is the performance issue when putting C++ codes into C#. Does anyone has any idea(s) on this issue????
4
32297
by: mechweb | last post by:
Hi all, I can successfully store an array in a session variable like so: string arr1 = new string; Session = arr1; But, when I try to display the elements (using the code below) on another page I get this error: txtmyarray.Text = Session;
1
2191
by: Wim | last post by:
Hi Everyone, I'm trying to speed up a Asp.net 1.1 applications' performance. The application needs to run in an environment with little bandwith and therefore pagesizes and roundtrip times shoud be brought back to a minimum. The application suffered from relatively large screens. A typical aspx page was 500 Kbyte so page load times were in the order of 40 - 50 seconds. After unsufficient loading improvement using .net caching
10
4273
by: shsandeep | last post by:
The ETL application loaded around 3000 rows in 14 seconds in a Development database while it took 2 hours to load in a UAT database. UAT db is partitioned. Dev db is not partitioned. the application looks for existing rows in the table...if they already exist then it updates otherwise inserts them. The table is pretty large, around 6.5 million rows.
7
2681
by: ltarrant | last post by:
Hi, I'm having problems with a DataTable I'm storing in a session variable. I use this as a temporary store for a shopping cart until a customer goes through the checkout and the cart is saved to my database. I have used DataTables stored in sessions before for shopping baskets with no problems. However, on this occasion I am only passing the AddHandler the product id and the quantity being added. The Handler then calls a getProductDetail...
0
1681
by: itsmenarwal | last post by:
HI everyone 1. As user enter username and password in sign-in-form.php then values are collected in sign-in-action-form.php page and the i am storing username into session variable like this In database i have a table named employee <a href="logout_file.php">Sign Out</a> if (username and passwords are matched) { session_start(); $_SESSION = $row; $_SESSION =$row;
0
7882
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
8017
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8250
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6671
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
5837
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5416
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
2391
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1490
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1222
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.