I guess that's not ideal that it hits SQL - but for some reson mini-profiler is flagging that the SAME SQL is being called more than once - I guess that's because it is being called for each Partial which inherits from Umbraco.Web.Mvc.UmbracoTemplatePage
I guess my question is - can this call be removed at all - or at least the number of calls reduced?
Thanks for that - I think I had come across this before- as in the back of my mind I remember reading something about Template caching, but I couldn't find anything here...
Is this issue fixed? We have a site running on 6.1.1 with this issue. We expect a lot of visitsors so a roundtrip to the db will have some impact on the db.
Template Lookup SQL - Mini Profiler Umbraco 6.1
Not quite sure where this should go - perhaps it should go in the Google Group - rather than here, on our??
The new mini-profiler is great, but one thing has been bugging me - each page load appears to hit SQL Server - with a query - similar to this one:
I guess that's not ideal that it hits SQL - but for some reson mini-profiler is flagging that the SAME SQL is being called more than once - I guess that's because it is being called for each Partial which inherits from Umbraco.Web.Mvc.UmbracoTemplatePage
I guess my question is - can this call be removed at all - or at least the number of calls reduced?
Hello,
There is already an issue for this: http://issues.umbraco.org/issue/U4-1970
It will be fixed in v7 by storing the template alias instead of the id on the node.
Jeroen
Eventually templates will not be saved in the database anymore so that will also fix the sql lookup ;-) http://issues.umbraco.org/issue/U4-59
Jeroen
Hi Jeroen,
Thanks for that - I think I had come across this before- as in the back of my mind I remember reading something about Template caching, but I couldn't find anything here...
Sounds like it will great when v7 comes out then!
Ian
Is this issue fixed? We have a site running on 6.1.1 with this issue. We expect a lot of visitsors so a roundtrip to the db will have some impact on the db.
Dennis
is working on a reply...