Re: [PERFORM] Two servers - One Replicated - Same query

2011-04-12 Thread Kevin Grittner
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

[PERFORM] Two servers - One Replicated - Same query

2011-04-11 Thread Ozer, Pam
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