473,322 Members | 1,287 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-wide DataSet

Hi there!

Many of you already discussed of datasets stored in cache for an asp.net
application.

I stored a "large?" dataset (nearly 4000 records) in an Application
variable, which contains a cached copy of all main tables (four) from a SQL
database, and some calculated statistics. Data in this tables is used in many
webcontrols on nearly all webforms in the application (datagrids,
dropdownlists and treeviews). SQL queries to get this data were not very
fast, so I decided to put everything in cache.

Users may also update data, which forces me to keep the cached dataset
constantly updated.

Now I worked on those sql queries to improve their performance, and got them
fast enough to let me think that maybe I don't need a cached dataset. But the
database could grow, hindering the performance of the queries, or consuming
more memory in the cached dataset.

I really don't know if I should continue to use a cached dataset or simply
read/write directly to/from the database on each web request.

Anybody could give me some suggestion? Thank you!

Bye!
Jan 20 '06 #1
1 1054
Not sure why you need to look at this as an all-or nothing. Can't sub-parts
of your data be cached? the more stale data? Even if it's the smaller piece
of information, it might help reduce the overall load.

Karl

--
http://www.openmymind.net/

"=WereWolf=" <We******@discussions.microsoft.com> wrote in message
news:56**********************************@microsof t.com...
Hi there!

Many of you already discussed of datasets stored in cache for an asp.net
application.

I stored a "large?" dataset (nearly 4000 records) in an Application
variable, which contains a cached copy of all main tables (four) from a
SQL
database, and some calculated statistics. Data in this tables is used in
many
webcontrols on nearly all webforms in the application (datagrids,
dropdownlists and treeviews). SQL queries to get this data were not very
fast, so I decided to put everything in cache.

Users may also update data, which forces me to keep the cached dataset
constantly updated.

Now I worked on those sql queries to improve their performance, and got
them
fast enough to let me think that maybe I don't need a cached dataset. But
the
database could grow, hindering the performance of the queries, or
consuming
more memory in the cached dataset.

I really don't know if I should continue to use a cached dataset or simply
read/write directly to/from the database on each web request.

Anybody could give me some suggestion? Thank you!

Bye!

Jan 20 '06 #2

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

Similar topics

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...
3
by: Amit Dedhia | last post by:
Hi I am developing a Dot net application (involving image processing) on a uni processor. It works well on my machine. I then take all my code on a multi processor, build and run the application...
6
by: orekin | last post by:
Hi There I have been trying to come to grips with Application.Run(), Application.Exit() and the Message Pump and I would really appreciate some feedback on the following questions .. There are...
20
by: Peter Oliphant | last post by:
How does one launch multiple forms in an application? Using Photoshop as an example, this application seems to be composed of many 'disjoint' forms. Yet, they all seem somewhat 'active' in...
6
by: Josef Brunner | last post by:
Hi, I published my application (VS 2005) and am now trying to install it when I get this error message. It worked before...even on a different machine. Here is the detailed description: ...
9
by: jeff | last post by:
Hi All. I realize that when my Deployed winforms application starts, Windows needs to load the .net 2 framework before control is given to my application.... Is there anyway to either ... -...
3
by: asadikhan | last post by:
Hi, I have written a windows application with a GUI (let's call it MENU). I own the code for this application and have access to it. We have another application that is a third-part windows...
2
by: Michael Kalika | last post by:
Hi, We have developed a VSTO 2005 Excel application and we would like to leverage ClickOnce deployment mechanism for distribution of this application. How can we do that? I was digging in MSDN...
0
by: Tifer | last post by:
Hello, I am building my first .Net Application. The first couple of Publish and Installs I did went fine. But after a couple of builds, I get a modal dialogue box error every time upon trying...
4
by: Dave | last post by:
I have a global.asax file with Application_Start defined and create some static data there and in another module used in the asp.net application and I realize that static data is shared amongst...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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: 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: 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: 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
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.