Click here to Skip to main content
11,702,396 members (70,015 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 Maciej Los 515
1 Sergey Alexandrovich Kryukov 355
2 OriginalGriff 299
3 CHill60 145
4 Mika Wendelius 115
0 OriginalGriff 8,369
1 Sergey Alexandrovich Kryukov 7,547
2 CPallini 4,922
3 Maciej Los 4,411
4 Mika Wendelius 3,556

Advertise | Privacy | Mobile
Web01 | 2.8.150819.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