Re: mysql query takes too much time to run

At 07:00 AM 1/13/2010, F.A.I.Z.A.L wrote: where ( ATX_Status.Status like '%running%' or ATX_Status.Status like '%queued%' or ATX_Status.Status like '%migrating%' or ATX_Status.Status like '%loading%' or ATX_Status.Status like '%configuring%' or ATX_Status.Status like '%activating%' ) It looks l

Re: mysql query takes too much time to run

Sac, this is like saying I have a pain, what can it be? Attach more info if you hope in some help, at least the explain plan. Cheers Claudio 2010/1/13 F.A.I.Z.A.L > hi > > can anybody help me to check this query is written in good way > > select ATX_Status.Server as `Server`, ATX_Status.Load

mysql query takes too much time to run

hi can anybody help me to check this query is written in good way select ATX_Status.Server as `Server`, ATX_Status.Load as `Load`,ATX_Status.System as `System`, atx.ATX_Status.Timestamp as `TimeStamp`, `Coverage`, atx.ATX_Summary.Testware as `View`, `Traffic`, ATX_Status.Status as `Status`, ATX_R