A question: If I introduce some new datatables into my umbraco app to store some traditional SQL data, and then use an asp.net custom control to display that data from one or more tables in my umbraco website, will umbraco perform any caching for me? or will data be pulled from the sql db every time the page refreshes?
As far as I know, if you have the custom control in a macro, and enable caching, then Umbraco will cache the output for you. Otherwise the data will be pulled out every time the control is loaded.
If the user control doesn't need to interact with the Umbraco context, and you don't need to let the users add the control to content pages via the Richtext editor, then I'd consider embedding the user control directly into your template and using .Net caching on the control, as you'll cut out the unecessary step of creating the macro.
Does umbraco cache 'custom' data from non-umbraco tables
A question: If I introduce some new datatables into my umbraco app to store some traditional SQL data, and then use an asp.net custom control to display that data from one or more tables in my umbraco website, will umbraco perform any caching for me? or will data be pulled from the sql db every time the page refreshes?
As far as I know, if you have the custom control in a macro, and enable caching, then Umbraco will cache the output for you. Otherwise the data will be pulled out every time the control is loaded.
If the user control doesn't need to interact with the Umbraco context, and you don't need to let the users add the control to content pages via the Richtext editor, then I'd consider embedding the user control directly into your template and using .Net caching on the control, as you'll cut out the unecessary step of creating the macro.
Hope that helps!
is working on a reply...