473,384 Members | 1,854 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,384 software developers and data experts.

Database Access vs Turning on SessionState

CW
My asp application currently does not rely on session state at all, and I
have turned it off.

The function that I need to implements include a customer specific price
list. I am thinking of cacheing the price list (which is different for each
customer) in session variables rather than retrieving a copy of the customer
price list each time.

On one hand, with the database approach, each time a customer browses a
price list, it entails not only a round trip to the server, but also a round
trip access to the database server. On the other hand, with the session
state approach, if the same customer goes to a different page, and then
comes back to the price list url, the page can loads information directly
from cache stored in session.

Which approach is better?
Nov 18 '05 #1
1 1297
If the price list is big I would prefer retrieving it from the database, rather than stroing it in servers' memory using Sessions

Rasika Wijayaratne
Nov 18 '05 #2

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

Similar topics

3
by: LaurenW | last post by:
My company has an A2K app that has been running just fine for a long time. Recently, some users notice that the database window appears when some forms are loaded. Right before we release a...
3
by: Leinad Kong | last post by:
I'm using Access 2002, as front-end and back-end as well: 1) I faced database corrupted problems, when more than 1 user edit concurrently. I'm using All-records Locking, and open-exclusively as...
3
by: CW | last post by:
My asp application currently does not rely on session state at all, and I have turned it off. The function that I need to implements include a customer specific price list. I am thinking of...
29
by: Patrick | last post by:
I have the following code, which regardless which works fine and logs to the EventViewer regardless of whether <processModel/> section of machine.config is set to username="SYSTEM" or "machine" ...
16
by: Brad | last post by:
After compiling my asp.net project I'm receiving a "BC31011 - Access is denied" error when attempting to run or debug. The only thing that seems to resolve problem is IISReset. After a reset my...
2
by: jamezw | last post by:
Hello I work on a website where we have 3 servers running one site so we use the SQLServer option for state management. We are using the persistent ASPState database. All 3 of our webservers are...
8
by: Mark A. Sam | last post by:
Hello I am working locally with Visual Web Developer 2005 Express. Before I even installed it, the information from Microsoft was that you could FTP it to a remote site and it should work. The...
0
by: Jonathan Wood | last post by:
I seem to be having errors creating and accessing an SQL database. Unfortunatley, I am brand new to SQL setup and administration issues so this really is not my area of expertise. I know I had...
2
by: =?Utf-8?B?THVib21pcg==?= | last post by:
Hi, I am learning how to access MS SQL database from ASP.NET and run into 2 problems: 1/ When a user from asp page is connected to database, I can not connect to the database from windows...
0
by: =?Utf-8?B?THVib21pcg==?= | last post by:
Hi, I am learning how to access MS SQL database from ASP.NET and I run into 2 problems: 1/ When a user from asp page is connected to database, I can not connect to the database from windows...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

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.