Re: Slow performance when using LIMIT 1000

[Rick James]

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;