Allow Connections to GDB while Rebuilding Indexes?

Question

Hello,

I haven't been allowing users to connect to the database while I rebuild indexes after compressing; when I have done so in the past there are performance issues on the user's end. However, I see in the below link to a python script, that users are allowed to connect while the rebuild is happening:

http://desktop.arcgis.com/en/arcmap/10.4/manage-data/geodatabases/using-python-scripting-to-batch-reconcile-and-post-versions.htm#ESRI_SECTION1_B145598651854AAD81AAF2C63FE9C32A

I'd like to allow user's to connect since rebuilding indexes can take several hours to complete but I am leary that not only would there be performance issues but also a possibility of corruption of data. Can anyone speak to this?

Thanks,

Ana

anayoung · Answer

Sure - that could work, as long as the script runs as expected. I'll run it by everyone and test it out.

Thanks, George.

George_Thompson · Answer

What if you did a combination of manually reconcile/post of the version on Friday and have the rest of the administration tasks: compress, analyze, rebuild indexes, etc. run during the evening?

anayoung · Answer

We had a script that we ran every night at 7pm but we found it wasn't pushing up the data. It appears to be a script written from the geo-processing results from running the tool "Reconcile Versions".

Every Friday I run maintenance which includes posting up from QA_Edit to Edit_Default to Default. We ask our editors to push up their own edits from their child version to QA_Edit before maintenance on Friday. However, for the better half of Fridays, the editors aren't working. So, I'm looking for a solution other than me working passed quitting time on Fridays.

The python script link I sent seems like it would be good to put on a schedule but I'd like to only post from QA_Edit up and not include the child versions of QA_Edit.

Thanks,

Ana