Re: slow query on replication master and slave

2010-04-27 Thread Johan De Meersman
On Wed, Apr 28, 2010 at 12:17 AM, Kandy Wong wrote: > Is it true that the performance of running a query on a live replication > master and slave has to be much slower than running a query on a static > server? > > I've tried to run the following query on a replication master and it takes > 1 min

slow query on replication master and slave

2010-04-27 Thread Kandy Wong
Hi, Is it true that the performance of running a query on a live replication master and slave has to be much slower than running a query on a static server? I've tried to run the following query on a replication master and it takes 1 min 13.76 sec to finish. SELECT *, ABS(timeA-1266143632) a