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

    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

    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 273 posts 584 karma points
    Jun 22, 2015 @ 15:29

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


  • Wojciech Tengler 95 posts 198 karma points
    Oct 06, 2015 @ 09:52
    Wojciech Tengler

    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.

Please Sign in or register to post replies

Write your reply to: