Click here to Skip to main content
Rate this: bad
good
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?



Thanks
Posted 27-Sep-12 12:56pm

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

  Print Answers RSS
0 OriginalGriff 515
1 Maciej Los 349
2 Richard MacCutchan 220
3 BillWoodruff 209
4 Mathew Soji 160
0 OriginalGriff 8,654
1 Sergey Alexandrovich Kryukov 7,407
2 DamithSL 5,639
3 Maciej Los 5,229
4 Manas Bhardwaj 4,986


Advertise | Privacy | Mobile
Web03 | 2.8.1411023.1 | Last Updated 27 Sep 2012
Copyright © CodeProject, 1999-2014
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