473,322 Members | 1,403 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,322 software developers and data experts.

Application or cache

Hi there,

In my application I need a dataset containing tables often used in pages.
They must be always available so I though Application would likely be the
best place to store the dataset. But what about Cache?. Would it be better
to load the dataset in cache and reload it when it expires?.

Thanks in advance,
Stefano Mostarda MCP
Rome Italy
Nov 18 '05 #1
2 1068
When you store in Application, you are essentially storing in cache,
although you are setting an extremely long lifetime, in most instances. You
can set up a mechanism to refresh this DataSet routinely.

Cache is a bit more flexible, however, as you have a bit more granularity on
lifespan of the DataSet, which is nice. I would recommend this over
application in instances where the data can change. NOTE: This is not real
time, but it is closer.

Using Notification Services in SQL Server, you can keep cache up to date,
but you will have to code this. This gives you a closer to real time DataSet
cache. With Yukon (out next year), you will have further options.

Take a look at the free Caching Application Block, which is rather nice:

http://www.microsoft.com/downloads/d...displaylang=en

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************
"stefano mostarda" <st**************@fastwebnet.it> wrote in message
news:O6**************@tk2msftngp13.phx.gbl...
Hi there,

In my application I need a dataset containing tables often used in pages.
They must be always available so I though Application would likely be the
best place to store the dataset. But what about Cache?. Would it be better
to load the dataset in cache and reload it when it expires?.

Thanks in advance,
Stefano Mostarda MCP
Rome Italy

Nov 18 '05 #2
The Application Cache is the best way to go. The Application Collection is
still available, but is not thread-safe, and lacks the additional
functionality of the Cache.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"stefano mostarda" <st**************@fastwebnet.it> wrote in message
news:O6**************@tk2msftngp13.phx.gbl...
Hi there,

In my application I need a dataset containing tables often used in pages.
They must be always available so I though Application would likely be the
best place to store the dataset. But what about Cache?. Would it be better
to load the dataset in cache and reload it when it expires?.

Thanks in advance,
Stefano Mostarda MCP
Rome Italy

Nov 18 '05 #3

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

Similar topics

8
by: Google Mike | last post by:
I need an Application object replacement. I was creating my own using shared memory -- shm* API in PHP. I was doing fine for 6 months until it just got too fat, I guess, and the RH9 Linux server...
9
by: J. Baute | last post by:
I'm caching data in the Application object to speed up certain pages on a website The main reason is that the retrieval of this data takes quite a while (a few seconds) and fetching the same data...
6
by: Stanley | last post by:
has anyone managed to use cache application block in a web application? thanks stanley
3
by: Patrick | last post by:
Hi I have the following problem. When starting my asp.net application, i read a encrypted string from a file, decrypt it and want this values to be available in the complete application. they...
4
by: Keith Chadwick | last post by:
I am having some trouble referencing an Application("myVar") variable from within a module.vb file on my ASP.NET site. According to the documentation I should be able to reference...
5
by: stefano mostarda | last post by:
Hi there, I have a question. In my application I have a table which is frequently used to fill a combo. I want to store it in the application or cache object. it is never updated. What's...
7
by: Greg Collins [MVP] | last post by:
Hi, I couldn't find what I was looking for by searching the newsgroup, but perhaps these have already been discussed somewhere. This is a bit long with a lot of interrelated questions. What I've...
4
by: Omega | last post by:
I just recently recieved my full copy of Visual Studio 2005 (excited!!!), and have gone head first into writing my first application. Sadly, I've hit a design barrier. >From what I can see,...
4
by: Fred Nelson | last post by:
Hi: This is probably a newby question however I can't figure it out! I'm trying to use application data caching in a web application. I have read an article on 4 guys from rolla that shows...
5
by: J055 | last post by:
Hi The following code works on my develeopment machine using the VS web server. When I run the application on 2 other Windows 2003/IIS 6 servers no caching seems to take place at all. Can...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.