MySQL Forums
Forum List  »  Performance

Re: Slow performance when using LIMIT 1000
Posted by: Rick James
Date: February 27, 2015 01:09AM

See if this runs faster:
      ( SELECT  *
            FROM  GroupCall
            WHERE  CallInitiated >= '2015-02-16 20:10:00'
              AND  CallInitiated < '2015-02-16 20:50:00'
            ORDER BY  CallInitiated DESC
            LIMIT  1000 
      )
    UNION  DISTINCT 
      ( SELECT  *
            FROM  GroupCall
            WHERE  CallBegin >= '2015-02-16 20:10:00'
              AND  CallBegin < '2015-02-16 20:50:00'
            ORDER BY  CallInitiated DESC
            LIMIT  1000 
      )
    ORDER BY  CallInitiated DESC
    LIMIT  1000; 

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Slow performance when using LIMIT 1000
1004
February 27, 2015 01:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.