topic Allow Connections to GDB while Rebuilding Indexes? in Data Management Questions

Allow Connections to GDB while Rebuilding Indexes?

anayoung — Fri, 19 Jul 2019 17:20:23 GMT

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

Re: Allow Connections to GDB while Rebuilding Indexes?

George_Thompson — Fri, 19 Jul 2019 17:32:40 GMT

Are you rebuilding the indexes and doing the other admin tasks during non-business hours? This may remove the issue of having users wanting to connect?

Geodatabase‌

Re: Allow Connections to GDB while Rebuilding Indexes?

anayoung — Fri, 19 Jul 2019 18:44:53 GMT

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

Re: Allow Connections to GDB while Rebuilding Indexes?

George_Thompson — Fri, 19 Jul 2019 18:53:55 GMT

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?

Re: Allow Connections to GDB while Rebuilding Indexes?

anayoung — Fri, 19 Jul 2019 19:18:03 GMT

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

Thanks, George.