Options

SQL Source control performance

AdrianGAdrianG Posts: 3 New member
edited October 15, 2020 4:21PM in SQL Source Control
https://documentation.red-gate.com/soc/configuring/disable-automatic-refreshing

The tag below mentioned in above link for RedGate_SQLSourceControl_CommonUI_UIOptions.xml does not exist in the installation I have...

Has this issue been fixed in latest build or is below tag moved to another location? 
The help link will need to be updated if so.

<DisableAutoRefresh>True</DisableAutoRefresh>


Contents of the file in my installation 

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<!---->
<UIOptions version="1" type="UIOptions">
  <CloseProgressDialogsOnCompletion>True</CloseProgressDialogsOnCompletion>
  <ShowTabOnSSMSStart>False</ShowTabOnSSMSStart>
  <AssemblyVersion>7.2.4.11418</AssemblyVersion>
  <PostAddToolTipDismissed>True</PostAddToolTipDismissed>
  <PostConflictInteractiveHelpShown>True</PostConflictInteractiveHelpShown>
  <PreviouslyLinked>True</PreviouslyLinked>
</UIOptions>

Tagged:
· Share on Twitter

Best Answer

  • Options
    David_DDavid_D Posts: 26 Bronze 2
    edited October 16, 2020 8:20PM Answer ✓
    Hello @AdrianG,

    Thanks for your post!

    SQL Source Control automatically refreshes the list of changes in the commit and get latest tabs. In order to improve performance, you'd have to add in the option yourself to disable auto refresh. For example, your UI Options .xml file might look like:

    <?xml version="1.0" encoding="utf-8" standalone="yes"?>
    <!---->
    <UIOptions version="1" type="UIOptions">
      <CloseProgressDialogsOnCompletion>True</CloseProgressDialogsOnCompletion>
      <ShowTabOnSSMSStart>False</ShowTabOnSSMSStart>
      <AssemblyVersion>7.2.4.11418</AssemblyVersion>
      <PostAddToolTipDismissed>True</PostAddToolTipDismissed>
      <PostConflictInteractiveHelpShown>True</PostConflictInteractiveHelpShown>
      <PreviouslyLinked>True</PreviouslyLinked>
      <DisableAutoRefresh>True</DisableAutoRefresh>
    </UIOptions>

    I hope this answer helps you out! Don't hesitate to let me know if you have any other questions.
    · Share on Twitter

Answers

Sign In or Register to comment.