473,756 Members | 6,852 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Page output caching for database driven pages?

What are best practices for page output caching on pages that are dynamically
generated from database tables.

Our site has left-hand navigation that is comprised of dynamically generated
menus of product categories. The categories are taken from several database
tables which rarely change.

This left-hand navigation is included on every single page in the site and
as such is wrapped up in a user-control. However, when I enabled caching on
the user-control, all DHTML and events cease to work properly.

Really confused!

Ben

However, when I tried applying
Jan 17 '06 #1
1 1343
Ben,
if the menus are built from data that comes from the database in the form of
a DataSet or DataTable, the most appropriate caching method would be to cache
that DataTable or DataSet and have the control look to the Cache first for it.
You don't need to specifically enable output caching on the control itself.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Ben Fidge" wrote:
What are best practices for page output caching on pages that are dynamically
generated from database tables.

Our site has left-hand navigation that is comprised of dynamically generated
menus of product categories. The categories are taken from several database
tables which rarely change.

This left-hand navigation is included on every single page in the site and
as such is wrapped up in a user-control. However, when I enabled caching on
the user-control, all DHTML and events cease to work properly.

Really confused!

Ben

However, when I tried applying

Jan 17 '06 #2

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

Similar topics

0
2135
by: Martin | last post by:
Hi. I had a very frustrating afternoon and evening but I have got it all under control now so all of a sudden I am in a good mood. I want to share some insights on output caching with you lot. After looking at the use of the OutputCache directive and tinkering with it a bit I found its usability.very limited. Think of it: it is okay for static content. Well that's nice but no big deal. Static content is cheap anyway, the file system...
2
1351
by: Tim Mavers | last post by:
Is there a setting in the web.config that will enable page-output caching for an entire site? All the documentation I find on output caching deals at the page or sub-page level. I saw a couple posts on Usenet that made reference to a "web.config" setting, but didn't actually state what it was. I have a lot of pages I want to cache and would like to set it once instead of each page. Thanks,
3
2487
by: DC | last post by:
Hi, (ASP.Net 1.1) is it possible to (programmatically and globally) deactivate page fragment caching? We have only two scenarios, development stage where we want caching off and testing where we want caching on. Is this doable? I think there is a config switch in 2.0, anything in 1.1? TIA for any hint,
2
3009
by: NotGiven | last post by:
I am new to patterns and want to learn how to implement the PAGE CONTROLLER model for a web site that has log-in and where the pages are dynamic database driven pages. I will have many questions along the way but one is: -- It looks like you use $_GET variables to provide instrucitons for the next action. Can you use $POST instead? Advatnages /disadvantages of either? Thanks.
0
2182
by: jason | last post by:
hi experts, support.microsoft.com/kb/917072 and http://msdn.microsoft.com/msdnmag/issues/06/07/WebAppFollies/ As pointed out in these articles, users might get session variables belong to other user ? So ....Session state and kernel-mode output caching don't mix. Has this bug been fixed?
11
1366
by: JJ | last post by:
I want to create a web site with the page content being driven by my sql database. This would form the basis of a simple content management system. i.e. a particular page may be accessed by the url www.xyz.com/default.aspx?pageid=34 I can achieve this when each page is identical - e.g. contains my custom text/html control. The bit I am having problems with is:
1
1695
by: beaker | last post by:
Access Database-driven ASP page with embedded RSS feeds Hi, I know very little about web development in general - just some basic html scripting, CSS and a bit of XML. I've inherited a public sector site that is huge, almost entirely database driven and written almost exclusively in ASP. There are news, bulletin, events and publications pages which all key off Access databases. I need to associate RSS feeds with these pages, so...
0
1004
by: Bishop | last post by:
Every page of our website have dynamic database driven aspects and we are using some datasource caching now. Even though we need a database driven website, most of our pages would work just fine if cached for 8 or more hours. Is there a way to cach the entire page for 8+ hours with ASP.NET, IIS, and/or the user's browser?
25
2801
by: pereges | last post by:
Hello, I'm trying to build a database driven website for a library management system. The database is stored on a remote server which all of my team mates can access. I've installed MySQL, PHP and Apache on my machine. I'm a beginner and I really don't understand how to proceed. My biggest problem is how to connect to the database on remote mysql server ? Does php allow this kind of thing ? I'm interested in a web interface on my machine...
0
9212
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
9779
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
9645
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...
1
7186
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
6473
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();...
0
5069
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3742
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
2
3276
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2612
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.