Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Ian Smedley 97 posts 192 karma points
    Jun 26, 2013 @ 12:42
    Ian Smedley
    0

    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:

    SELECT *
    FROM [cmsTemplate]
    INNER JOIN [umbracoNode]
    ON [cmsTemplate].[nodeId] = [umbracoNode].[id]
    WHERE ([umbracoNode].[nodeObjectType] = '9fbfe604-4118-42ce-a30b-4a2600a2f07d')
    AND (umbracoNode.id = @0)  

    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?

    I notice the same warning in the screenshot of MiniProfiler on the announcment Blog.@ http://umbraco.com/follow-us/blog-archive/2013/5/10/umbraco-610-beta-2-out-now!.
  • Jeroen Breuer 4908 posts 12265 karma points MVP 5x admin c-trib
    Jun 26, 2013 @ 12:51
    Jeroen Breuer
    0

    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

  • Jeroen Breuer 4908 posts 12265 karma points MVP 5x admin c-trib
    Jun 26, 2013 @ 12:53
    Jeroen Breuer
    100

    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

  • Ian Smedley 97 posts 192 karma points
    Jun 26, 2013 @ 14:02
    Ian Smedley
    0

    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

  • Dennis Spijkerboer 53 posts 95 karma points
    Apr 04, 2014 @ 09:00
    Dennis Spijkerboer
    0

    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

Please Sign in or register to post replies

Write your reply to:

Draft