Performance analysis for MongoDB and MySQL

Server configuration:

Cpu:1 Core Memory: 2048 MB (I/O optimized) network bandwidth: 1Mcentos 7.0MongoDB 3.2
MySQL 5.6 Server table Data volume 1,184,545 MongoDB data is imported by MySQL, ensure the data consistent experiment prepared to execute the statement as: MySQL:

SELECT *
From sharelooks_30d m
WHERE m.lng>_lng1 and M.lng<_lng2 and M.lat>_lat2 and M.LAT<_LAT1
ORDER by ID DESC LIMIT 30;

Mongodb:

Db.sharelooks_30d.find (
{"LNG":
{"$GT": lng1, "$lt": Lng2},
"Lat":
{"$GT": Lat2, "$lt": LAT1}
}
). Sort ({"ID": -1}). Limit (30)

First time: MongoDB not added index: 1.5S

Mysql: Added index: 1.23S

After MongoDB adds an index:

Execution time is 0.2 seconds

To change the input parameters:

My is cut: 5.412S mongodb:1.1s

So probably the difference between the query 5-6 times

Performance analysis for MongoDB and MySQL