SQL Source control performance

AdrianG

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>

David_D

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.

AdrianG

Ah, thank you.  I didn't read step 4 of the instructions clearly enough!
 "Inside the <i><UIOptions></i> tags, add:"