Ozer, Pam po...@automotive.com wrote:
I have two servers one has replication the other does not. The
same query on both servers. One takes 225seconds on the
replicated server the first time it runs and only 125ms on the
other server the first time it runs. The second time you execute
the
I have two servers one has replication the other does not. The same
query on both servers. One takes 225seconds on the replicated server
the first time it runs and only 125ms on the other server the first time
it runs. The second time you execute the query it drops to the 125ms.
They are using