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?