Create user-schema to make management of state tree more efficient?

MarkChilcott

Hi Peoples,

When I access a feature class in an Enterprise Geodatabase that is not registered as versioned – will the version tree and state tree effect performance?

 

Our PROD database is 99% simple read only feature classes.  There are one or two feature classes that are registered as versioned.  We are considering placing the versioned data into a user-schema geodatabase with the thought that it would make compress back to state zero easier, and thus make management of the instance more efficient.  Ie we would not have to kick all the users off the database to do a successful compress back to state zero – just the schema user.

 

… or are we overthinking this?

 

Cheers,

Mark

AlexanderBrown5

Mark,

As George indicated, most of your data is not versioned.  It will not impact performance if you only have one or two feature classes registered as versioned; unless you have an enormous number of edits. 

If you are only doing dozens of edits per week for each feature class, it should not be difficult to reconcile, post, delete versions, and compress weekly.  

After doing your reconcile/post and deleting all versions after Default, I would suggest utilizing the ArcPy commands to complete your process.  In simple form:

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> time
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env

<SPAN class="comment token"># Set the workspace</SPAN>
workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'Database Connections\SDE_CONNECTION_TO_DATABASE.sde'</SPAN>
env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> workspace

database_name <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>workspace<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'\\'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Block new connections to the database.</SPAN>
<SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'Blocking connections in %s'</SPAN> <SPAN class="operator token">%</SPAN> database_name
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>AcceptConnections<SPAN class="punctuation token">(</SPAN>workspace<SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">except</SPAN> <SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>ExecuteError<SPAN class="punctuation token">,</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ExecuteWarning<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> e<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> e

<SPAN class="comment token"># wait 120 seconds</SPAN>
time<SPAN class="punctuation token">.</SPAN>sleep<SPAN class="punctuation token">(</SPAN><SPAN class="number token">120</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Disconnect all users from the database.</SPAN>
<SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'Disconnecting all users from %s...'</SPAN> <SPAN class="operator token">%</SPAN> database_name
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>DisconnectUser<SPAN class="punctuation token">(</SPAN>workspace<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ALL"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">except</SPAN> <SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>ExecuteError<SPAN class="punctuation token">,</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ExecuteWarning<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> e<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> e

<SPAN class="comment token"># Run the compress tool.</SPAN>
<SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'Compressing database...'</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Compress_management<SPAN class="punctuation token">(</SPAN>workspace<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">except</SPAN> <SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>ExecuteError<SPAN class="punctuation token">,</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ExecuteWarning<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> e<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> e

<SPAN class="comment token"># Allow the database to begin accepting connections again</SPAN>
<SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'Accepting Connections from %s...'</SPAN> <SPAN class="operator token">%</SPAN> database_name
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>AcceptConnections<SPAN class="punctuation token">(</SPAN>workspace<SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">except</SPAN> <SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>ExecuteError<SPAN class="punctuation token">,</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ExecuteWarning<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> e<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> e<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

AcceptConnections—Help | ArcGIS for Desktop 

DisconnectUser—Help | ArcGIS for Desktop 

ListUsers—Help | ArcGIS for Desktop 

You can of course also script your reconcile and post, but many organizations like to go through that process manually to verify/determine any conflicts.

In short, a few versioned feature classes will not adversely affect your databases performance; I would advise against creating a user schema geodatabase for this use case.

~Alex