Copied to clipboard

Flag this post as spam?

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


  • Simon Hewitt 65 posts 126 karma points
    Oct 03, 2014 @ 11:33
    Simon Hewitt
    0

    Indexing contour tables

    Hi Tim,

    Quite a few months ago Mayflymedia put up a blog post about speeding up Contour by adding non-clustered indexes on certain guids (as seen here http://www.mayflymedia.co.uk/blog/speeding-up-umbraco-contour-by-800-percent/).

    Do you have an update script available or could you specify which fields I would need to index. It would be useful to know so I don't have to index them all and then have a bigger rebuild job than necessary.

    Cheers Simon

  • Jules 205 posts 448 karma points
    Jun 22, 2015 @ 15:29
    Jules
    0

    This is pretty old now. Did you get an answer to this or resolve the issue?

    Jules

  • wtct 87 posts 130 karma points
    Oct 06, 2015 @ 09:52
    wtct
    0

    In my opinion critical is the lack of indexes in tables:

    • UFRecordDataBit
    • UFRecordDataDateTime
    • UFRecordDataInteger
    • UFRecordDataLongString
    • UFRecordDataString

    I have just created non-clustered, non-unique indexes for [key] column and form saving is much faster.

  • 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