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 4909 posts 12266 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 4909 posts 12266 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

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies