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 276 posts 588 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

  • Wojciech Tengler 96 posts 207 karma points
    Oct 06, 2015 @ 09:52
    Wojciech Tengler
    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