Click here to Skip to main content
13,146,315 members (47,844 online)
Rate this:
Please Sign up or sign in to vote.
I need to allow users to edit text on a number of web pages and was thinking of storing this text in the database and creating a user control to query the database to get the text when the page loads.

If I use a usercontrol pasted onto the page with a database row id, each control could retrieve and display the text without me having to bind each piece of text manually. These controls could also contain the edit functionality.

BUT….Suppose the page has 20 of these usercontrols, the DB would be hit 20 times each time the page is loaded……..bad news indeed.

I was thinking about caching the page so it would only ever get hit e.g. once a day with these 20 retrievals and/or wrapping them in a transaction or something.

Is there a good way of achieving this?

Posted 27-Sep-12 11:56am

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.170915.1 | Last Updated 27 Sep 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100