Copied to clipboard

Flag this post as spam?

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


  • Johan Larsson 28 posts 98 karma points
    Jan 28, 2015 @ 13:43
    Johan Larsson
    0

    A lot of calls to the database

    I have installed the 301 URL Tracker version 3.3 on my Umbraco 7.1.6 site, when running an SQL profiler to see all SQL calls that my system do to the database I can find a lot of calls to the icUrlTracker database table. Should not these calls be cached? Or have I missed something?

    The SQL command that is sent may differ from 20 to 50 times per Umbraco page, and every call is exactly the same:

    exec sp_executesql N'SELECT * FROM icUrlTracker WHERE Is404 = 0 AND ForceRedirect = @forceRedirect AND RedirectRootNodeId = @redirectRootNodeId AND OldRegex IS NOT NULL ORDER BY Inserted DESC',N'@forceRedirect int,@redirectRootNodeId int',@forceRedirect=1,@redirectRootNodeId=1076

     

  • Stefan Kip 1606 posts 4098 karma points c-trib
    Jan 28, 2015 @ 14:08
    Stefan Kip
    0

    Could you use Github for issues please?

  • Johan Larsson 28 posts 98 karma points
    Jan 28, 2015 @ 16:27
    Johan Larsson
    0

    Oh, sorry. I just thought I would report bugs to Github not questions, because I am not sure it is a bug.

    Now I have posted it to Github. :)

  • Stefan Kip 1606 posts 4098 karma points c-trib
    Jan 28, 2015 @ 16:28
    Stefan Kip
    0

    I understand, but it's impossible to manage reports on our umbraco.
    Some overview is needed and I use Github for that ;-)

    This might be a bug, or something that should be improved, so thanks for the suggestion and I'll reply on Github when there's any news.

  • 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