Comment 15 for bug 1362212

Steffen Boehme (boemm) wrote :

Even with bigger limit numbers it performs well:

mysql> explain select downloadco0_.id as id1_9_, downloadco0_.attempts as attempts2_9_, downloadco0_.dateCreated as dateCrea3_9_, downloadco0_.dateModified as dateModi4_9_, downloadco0_.downloadCompleted as download5_9_, downloadco0_.downloadStarted as download6_9_, downloadco0_.executionId as executio7_9_, downloadco0_.fileId as fileId8_9_, downloadco0_.fileSize as fileSize9_9_, downloadco0_.fulfillerId as fulfill10_9_, downloadco0_.platform as platfor11_9_ from DownloadConfirmation downloadco0_ where downloadco0_.platform='EU' and downloadco0_.fulfillerId='12' and downloadco0_.executionId='103906' and (downloadco0_.downloadCompleted is not null) order by downloadco0_.downloadCompleted asc limit 10\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: downloadco0_
         type: ref
possible_keys: platformFulfillerIdExecutionId,downloadCompleted
          key: platformFulfillerIdExecutionId
      key_len: 824
          ref: const,const,const
         rows: 977
        Extra: Using index condition; Using where; Using filesort
1 row in set (0.00 sec)