Click here to Skip to main content
11,806,575 members (40,665 online)
Rate this: bad
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
0 ppolymorphe 295
1 OriginalGriff 150
2 George Jonsson 135
3 Richard Deeming 120
4 CPallini 100
0 OriginalGriff 3,380
1 Maciej Los 1,990
2 CPallini 1,915
3 KrunalRohit 1,907
4 ppolymorphe 1,317

Advertise | Privacy | Mobile
Web01 | 2.8.151002.1 | Last Updated 27 Sep 2012
Copyright © CodeProject, 1999-2015
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