I have a table with 2 million records. 

Here is the table

```
comments
---------
    +-------------+---------------+------+-----+---------+----------------+
    | Field       | Type          | Null | Key | Default | Extra          |
    +-------------+---------------+------+-----+---------+----------------+
    | commentid   | int(11)       | NO   | PRI | NULL    | auto_increment |
    | parentid    | int(11)       | YES  |     | 0       |                |
    | refno       | int(11)       | YES  |     | 0       |                |
    | createdate  | int(11)       | YES  | MUL | 0       |                |
    | remoteip    | varchar(80)   | YES  |     |         |                |
    | fingerprint | varchar(50)   | YES  |     |         |                |
    | locid       | int(11)       | YES  | MUL | 0       |                |
    | clubid      | int(11)       | YES  |     | 0       |                |
    | profileid   | int(11)       | YES  | MUL | 0       |                |
    | userid      | int(11)       | YES  | MUL | 0       |                |
    | global      | int(11)       | YES  |     | 0       |                |
    | official    | int(11)       | YES  |     | 0       |                |
    | legacyuser  | int(11)       | YES  | MUL | 0       |                |
    | mediaid     | int(11)       | YES  |     | 0       |                |
    | status      | int(11)       | YES  |     | 1       |                |
    | comment     | varchar(4000) | YES  |     |         |                |
    | likes       | int(11)       | YES  |     | 0       |                |
    | dislikes    | int(11)       | YES  |     | 0       |                |
    | import      | int(11)       | YES  |     | 0       |                |
    | author      | varchar(50)   | YES  |     |         |                |
    +-------------+---------------+------+-----+---------+----------------+

```

Now this query against 2 million records takes 6 to 7 seconds:

```
select * from comments where (locid=2085 or global=1) and status>0 order by createdate desc limit 20;

```

**I decided to add an index to locid and it still produces results in 6 to 7 seconds**

I could have used a sqlfiddle but it would have been unneccessary since the basis of this question pertains to performance and I'm not adding 2mil records to sqlfiddle. 

**Are there any strategies or implementations which can get this query into the 3 seconds range?**

Thanks!

**UPDATE**

This is my explain show table.

```
        | comments | CREATE TABLE `comments` (
      `commentid` int(11) NOT NULL AUTO_INCREMENT,
      `parentid` int(11) DEFAULT '0',
      `refno` int(11) DEFAULT '0',
      `createdate` int(11) DEFAULT '0',
      `remoteip` varchar(80) DEFAULT '',
      `fingerprint` varchar(50) DEFAULT '',
      `locid` int(11) DEFAULT '0',
      `clubid` int(11) DEFAULT '0',
      `profileid` int(11) DEFAULT '0',
      `userid` int(11) DEFAULT '0',
      `global` int(11) DEFAULT '0',
      `official` int(11) DEFAULT '0',
      `legacyuser` int(11) DEFAULT '0',
      `mediaid` int(11) DEFAULT '0',
      `status` int(11) DEFAULT '1',
      `comment` varchar(4000) DEFAULT '',
      `likes` int(11) DEFAULT '0',
      `dislikes` int(11) DEFAULT '0',
      `import` int(11) DEFAULT '0',
      `author` varchar(50) DEFAULT '',
      PRIMARY KEY (`commentid`),
      KEY `comments_locid` (`locid`),
      KEY `comments_userid` (`userid`),
      KEY `idx_legacyusers` (`legacyuser`),
      KEY `profile_index` (`profileid`),
      KEY `comments_createdate` (`createdate`),
      KEY `compound_for_comments` (`locid`,`global`,`status`),
      KEY `global` (`global`),
      KEY `status` (`status`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3848451 DEFAULT CHARSET=latin1

```