slow query for me, but fast for others
Posted on 2004-10-05
This is a query that run in seconds for all my colleagues, but takes minutes for me. What might be the cause of this, and how do I correct it? (apart from the suggestion that it doesn't like me) Are there personal settings that affect my query performance? I am running this on a lightly loaded quad Xeon server with 4GB RAM, and as soon as I run it, the task manager shoots up to 100% and stays there, while for others the results come back in a few seconds.
p1.tnum, p1.trddt as 'date',
p1.inserttime as 'p1_in',
p2.inserttime as 'p2_in',
p3.inserttime as 'p3_in'
from trademaster p1, tradesupplement1 p2, tradesupplement2 p3
p1.trddt *=p2.trddt and p1.tnum *= p2.tnum
and p1.trddt *=p3.trddt and p1.tnum *= p3.tnum
and company not like 'mycompany%'
and p2.action like 'sendquote%'
and p2.seq =1
and p3.seq =2
and p1.tstmsg !='yes'
and p1.trddt = '09/30/04'