Copied to clipboard

Flag this post as spam?

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


  • Inx51 54 posts 107 karma points
    Jun 03, 2014 @ 23:51
    Inx51
    0

    Umbraco keeps doing UPDATEs in the SQL according to MiniProfiler?

    Hi! Im having a quite simple page.. with some text and some images.. All Im doing is FETCHING data from the cache and some media using examine (since the "normal"/new Media(int) is way to slow)

    Anyway.. The page is still very slow due to the fact that for some reason according to miniprofiler, umbraco keeps doing this:

    UPDATE [cmsPropertyData] SET [contentNodeId] = @0, [versionId] = @1, [propertytypeid] = @2, [dataInt] = @3, [dataDate] = @4, [dataNvarchar] = @5, [dataNtext] = @6 WHERE [id] = @7   
    

    A few times (like 30+ times).. so my first question is.. why?.. Im only fetching data.. not writing/updating.. And my last question is, is there anyway to avoid this? Since Im currently running my app in Azure each single database call is extremely expensive as far as latency comes.. so it would be really nice to avoid those calls.. especially when some of em are over 2000ms long in response-time.

    Any ideas?

    Br, Inx

Please Sign in or register to post replies

Write your reply to:

Draft