Data query performance test comparison between MySQL and MongoDB

After testing the batch insert yesterday, let’s test the read today. Due to many test items, I use my local computer to test: sempron2300+, 2G memory, xp 32-bit. For this test, I will take 1, 10, 20, 50, 100, 1000, 5000, 10000, 100000, 200000 as reference values Test condition 1: select id,a1,a2 from a order by id desc limit x Test condition 2: select id,a1,a2 from a where id>100000 order by id desc limit 1 Test condition 3: select id,a1,a2 from a where id>100000 order by id desc limit 200000, x select id,a1,a2 from a where id=’100000’… Test condition 6: select id,a1,a2 from a where id>’100000′ and id<'100050' order by id desc Based on the above data: mysql reads data faster than mongodb under the restriction of sorting query conditions Under the condition of reading a large result set, mysql reads data faster than mongodb; but when reading a small amount of data, mysql reads data slower than mongodb If you specify where, mysql reads data a little faster than mongodb, but as more and more where, mysql reads data faster than mongodb the the