I have a web application that will handle anywhere for 50 to 175 users at one
time but will likely have a user base in the 100s. This application contains
a GUI interface for the every day user and web services that can access the
GUI modules for 3rd party applications needing to get shared data
In the initial design plan, the idea was presented to retrieve the data for
the user’s dashboard and hold that data in session, only connecting to SQL
for the initial load and any update and delete. This way with each post back,
there us no need to connect to SQL to reload the data on a change. This is
b/c the SQL server is used by several in house applications not related to
this one and we had issues in the past of SQL server getting bogged down. So
the idea is to limit request to SQL with this application as needed. Its
cheaper for use to setup a dedicated web server then it is SQL server since
we have so many database that need to cross communicate, and SQL server
linking is just too slow and unreliable.
What is the trade offs of storing the session data in SQL? Even though it
still hitting SQL, I figure it’s still more efficient then executing the
entire query for the data. I know it would make it more scalable, but would
we not just end up back with SQL server getting bogged down again?
Now I realize holding entire dataset in memory is a big deal, in fact there
a 8 datasets per user. These datasets are quite small, anywhere from 1
datarow to up to 10 datarows.
The application is fast, but hasn’t been tested user say 50 simultaneous
users. Would you go with a RAM packed out web server dedicated to the app, or
store sessions in SQL on server that cannot be dedicated?
--
JP
..NET Software Developer
3  1376 
#1
Future posts on this topic would probably be better suited for:
microsoft.publi c.dotnet.framew ork.aspnet
There is a third option, which is http://msdn2.microsoft.com/en-us/lib...reference.aspx
The WeakReference class. You can weakreference object(s) in the Session,
and have "smart code" that figure out whether or not the data is cached, but
your have a work around if server strain is high.
Fourth option:
Don't use "bulky" dataset objects. Write custom objects/custom collections
to keep your data. They will probably have to be Serializable, but their
footprint ends up being smaller than a DataSet usually.
Fifth option. There are third party session state applications.
...
Take a look here; http://www.eggheadcafe.com/articles/20020302.asp
"JP" <JP@discussions .microsoft.comw rote in message
news:5E******** *************** ***********@mic rosoft.com...
>I have a web application that will handle anywhere for 50 to 175 users at
one
time but will likely have a user base in the 100s. This application
contains
a GUI interface for the every day user and web services that can access
the
GUI modules for 3rd party applications needing to get shared data
In the initial design plan, the idea was presented to retrieve the data
for
the user's dashboard and hold that data in session, only connecting to SQL
for the initial load and any update and delete. This way with each post
back,
there us no need to connect to SQL to reload the data on a change. This is
b/c the SQL server is used by several in house applications not related to
this one and we had issues in the past of SQL server getting bogged down.
So
the idea is to limit request to SQL with this application as needed. Its
cheaper for use to setup a dedicated web server then it is SQL server
since
we have so many database that need to cross communicate, and SQL server
linking is just too slow and unreliable.
What is the trade offs of storing the session data in SQL? Even though it
still hitting SQL, I figure it's still more efficient then executing the
entire query for the data. I know it would make it more scalable, but
would
we not just end up back with SQL server getting bogged down again?
Now I realize holding entire dataset in memory is a big deal, in fact
there
a 8 datasets per user. These datasets are quite small, anywhere from 1
datarow to up to 10 datarows.
The application is fast, but hasn't been tested user say 50 simultaneous
users. Would you go with a RAM packed out web server dedicated to the app,
or
store sessions in SQL on server that cannot be dedicated?
--
JP
.NET Software Developer
"JP" <JP@discussions .microsoft.comw rote in message
news:5E543DAD-B3FD-45DC->
The application is fast, but hasn’t been tested user say 50 simultaneous
users. Would you go with a RAM packed out web server dedicated to the app,
or
store sessions in SQL on server that cannot be dedicated?
A SQL Server State server is slower than holding state in memory on the Web
Server or an Application state server. If I had my choice, I would go with a
dedicated SQL Server box dedicated to keeping session state or an dedicated
Application state server, but these solutions are for a WEB server farm
implementation for the most part.
If you're not in that situation of a WEB server farm and you can't dedicate
a SQL server box to keep state, then you have to have the Web Server
dedicated to that one application with a lot of RAM. What other choice do
you have?
Assuming your user base doesn't get more than 10 times that amount,
storing it in memory is fine.
--
Robbe Morris [Microsoft MVP - Visual C#]
..NET PropertyGrid Control - ListBox, ComboBox, and Custom Classes http://www.eggheadcafe.com/tutorials...d-control.aspx
"JP" <JP@discussions .microsoft.comw rote in message
news:5E******** *************** ***********@mic rosoft.com...
>I have a web application that will handle anywhere for 50 to 175 users at
one
time but will likely have a user base in the 100s. This application
contains
a GUI interface for the every day user and web services that can access
the
GUI modules for 3rd party applications needing to get shared data
In the initial design plan, the idea was presented to retrieve the data
for
the user’s dashboard and hold that data in session, only connecting to SQL
for the initial load and any update and delete. This way with each post
back,
there us no need to connect to SQL to reload the data on a change. This is
b/c the SQL server is used by several in house applications not related to
this one and we had issues in the past of SQL server getting bogged down.
So
the idea is to limit request to SQL with this application as needed. Its
cheaper for use to setup a dedicated web server then it is SQL server
since
we have so many database that need to cross communicate, and SQL server
linking is just too slow and unreliable.
What is the trade offs of storing the session data in SQL? Even though it
still hitting SQL, I figure it’s still more efficient then executing the
entire query for the data. I know it would make it more scalable, but
would
we not just end up back with SQL server getting bogged down again?
Now I realize holding entire dataset in memory is a big deal, in fact
there
a 8 datasets per user. These datasets are quite small, anywhere from 1
datarow to up to 10 datarows.
The application is fast, but hasn’t been tested user say 50 simultaneous
users. Would you go with a RAM packed out web server dedicated to the app,
or
store sessions in SQL on server that cannot be dedicated?
--
JP
.NET Software Developer
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Jim Douglas |
last post by:
I am starting the analysis and design on how we are going to handle session
data. We are on a large web-farm which limits our solutions. The best
solution is persisting to MS SQLServer but I'm not comfortable with it's
single point of failure or maybe I am missing something there. QueryString
is out for security and HIPAA regulations and most other solutions are
'single-server', cache, etc. I have read the MSDN article titled "Nine
Options...
|
by: Gerald |
last post by:
Hi,
Is there any know problem using session variables ?
My website won't have more than 20 simultaneous connections, and i would
like to use 5 session variables containing strings...
I know than with ASP, it was not really recommended, what about ASP.NET ?
Thanks !
|
by: net4matrimonials |
last post by:
I m using session veriables of asp.net on two websites
www.net4professionals.com(job site) and www.net4matrimonials.com
(bride/groom service)
when i create a session on page A i use codeing
session.timeout=180
session("name")="xyz"
response.redirect("myaccountpage.aspx")
on page B to access session variable i use
|
by: Joe |
last post by:
I have an application which runs in a non-secure environment. I also have an
application that runs in a secure environment (both on the same machine). Is
there any way to share the session data for this?
Most of the site allows the user to add things to a cart (non-secure), once
they choose to check-out, I need this information which was stored in the
session to be read by the payment page(secured).
Hope this makes sense. It's probably...
|
by: LeAnne |
last post by:
My question is to do with scalability and the location for storate of cache,
session, viewstate and application data.
Application - Data is stored in memory (in process)
Session - Data is stored in memory (in process or out of process)
- can be configured to store the session data in sql server (which relates
to my question)
ViewState - Page (but can be modified to overwrite the storage mechanism to
store viewstate else where, esp...
| | |
by: Nick Gilbert |
last post by:
Hi,
Is it possible to access the Session of an arbitary user from an aspx page?
On an e-commerce site, I am notified of payment success via a callback
from the payment server to an ASPX page on my system. I would like to be
able to access the session of the user that submitted the order, and
clear their basket. I don't really want to store their session in the
database just to facilitate this.
|
by: davidkoree |
last post by:
I mean not about cookie.
Does it have something to do with operating system or browser plugin?
I appreciate any help.
|
by: j.wendelmuth |
last post by:
Hi,
i have a problem with PHP sessions. The problem only occurs on one
machine (PHP v5.2.4 incl. mod_security). On another one (PHP v5.2.0 no
mod security) my application works fine.
Here's the precondition:
I have 2 PHP applications, A and B. Both on a seperate server/machine.
A perfoms via SoapClient a request on B, where a Soap service is
located. B provides amongst others a function, that initializes a
|
by: =?Utf-8?B?UGF1bA==?= |
last post by:
Hi I have a web application vs2005 and it looks like a condition is causing
session veriables to be lost. This does not seem to be happening too often.
The web application allows uploading and deleting files on the server, but
not in the bin directory. I am not sure if this is related. Any idea what
might be causing this and how to fix it?
Thanks.
--
Paul G
Software engineer.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
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...
|
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...
|
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...
|
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();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
| | |
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...
| |
