topic Slow queries after replica sync in Data Management Questions https://community.esri.com/t5/data-management-questions/slow-queries-after-replica-sync/m-p/356423#M20437 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>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.&nbsp; For instance, a simple LIKE query on a single attribute of points goes from &lt; 2 seconds to nearly 10 seconds.&nbsp; This is really noticeable through ArcGIS Server map services.&nbsp; I can re-create the replica and the queries are back to normal (&lt; 2 seconds).&nbsp; The SDE gets a nightly cleaning/compressing/re-indexing.&nbsp; </P><P></P><P>Does anyone have any insights as to what might be the cause?&nbsp; Is there some post-sync cleanup to the file GDB's that can be done?&nbsp; It seems like the indexes are getting out of whack.</P><P></P><P>Thanks in advanced for any help.</P><P>Mike</P></BODY></HTML> Tue, 14 Jul 2015 14:56:09 GMT MichaelSnook 2015-07-14T14:56:09Z Slow queries after replica sync https://community.esri.com/t5/data-management-questions/slow-queries-after-replica-sync/m-p/356423#M20437 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>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.&nbsp; For instance, a simple LIKE query on a single attribute of points goes from &lt; 2 seconds to nearly 10 seconds.&nbsp; This is really noticeable through ArcGIS Server map services.&nbsp; I can re-create the replica and the queries are back to normal (&lt; 2 seconds).&nbsp; The SDE gets a nightly cleaning/compressing/re-indexing.&nbsp; </P><P></P><P>Does anyone have any insights as to what might be the cause?&nbsp; Is there some post-sync cleanup to the file GDB's that can be done?&nbsp; It seems like the indexes are getting out of whack.</P><P></P><P>Thanks in advanced for any help.</P><P>Mike</P></BODY></HTML> Tue, 14 Jul 2015 14:56:09 GMT https://community.esri.com/t5/data-management-questions/slow-queries-after-replica-sync/m-p/356423#M20437 MichaelSnook 2015-07-14T14:56:09Z