RE: My Query is TOOOOOOOOOOOO Slow :(

2002-05-03 Thread Jay Blanchard
You have written the following: [snip & arrange] SELECT idemailsent, email, idclient FROMwmkt_email_sent a, wmkt_client b, wmkt_email c WHERE nMachine = 0 AND c.idemail=a.fkemail AND b.f

Re: My Query is TOOOOOOOOOOOO Slow :(

2002-05-03 Thread Colin Faber
Hi Edilson, Increase your key and join buffers. also select your absolute values first. i.e.: SELECT idemailsent, email, idclient FROM wmkt_email_sent a, wmkt_client b, wmkt_email c WHERE fkuser = 1 AND fkpbl = 23 AND nMachine = 0 AND c.idemail=a.fkemail AND b.fkemail=a.fkemail ORDER BY email L