Slow queries after replica sync

2767
0
07-14-2015 07:56 AM
MichaelSnook
Occasional Contributor III

Hi All,

We have been replicating/syncing data from an SDE database for a while now and I've just started to notice that every few replica syncs to utility databases (file GDB's -- all created with 10.3) the queries to from those databases have slowed down dramatically.  For instance, a simple LIKE query on a single attribute of points goes from < 2 seconds to nearly 10 seconds.  This is really noticeable through ArcGIS Server map services.  I can re-create the replica and the queries are back to normal (< 2 seconds).  The SDE gets a nightly cleaning/compressing/re-indexing. 

Does anyone have any insights as to what might be the cause?  Is there some post-sync cleanup to the file GDB's that can be done?  It seems like the indexes are getting out of whack.

Thanks in advanced for any help.

Mike

0 Kudos
0 Replies