mongodb比mysql快么_MongoDB不比MySQL快吗？

几个月前我发现了mongodb，在阅读了本文post之后，我觉得mongodb确实比mysql快，所以我决定建立自己的工作台，问题是我的结果和上面文章的作者不一样，特别是在查询数据库时：mongodb似乎比MyISAM表慢。你能看看我的python代码吗，里面可能有什么问题：from datetime import datetime

import random

import MySQLdb

import pymongo

mysql_db=MySQLdb.connect(user="me",passwd="mypasswd",db="test_kv")

c=mysql_db.cursor()

connection = pymongo.Connection()

mongo_db = connection.test

kvtab = mongo_db.kvtab

nb=1000000

thelist=[]

for i in xrange(nb):

thelist.append((str(random.random()),str(random.random())))

t1=datetime.now()

for k,v in thelist:

c.execute("INSERT INTO key_val_tab (k,v) VALUES ('" + k + "','" + v + "')")

dt=datetime.now() - t1

print 'MySQL insert elapse :',dt

t1=datetime.now()

for i in xrange(nb):

c.execute("select * FROM key_val_tab WHERE k='" + random.choice(thelist)[0] + "'")

result=c.fetchone()

dt=datetime.now() - t1

print 'MySQL select elapse :',dt

t1=datetime.now()

for k,v in thelist:

kvtab.insert({"key":k,"value":v})

dt=datetime.now() - t1

print 'Mongodb insert elapse :',dt

kvtab.ensure_index('key')

t1=datetime.now()

for i in xrange(nb):

result=kvtab.find_one({"key":random.choice(thelist)[0]})

dt=datetime.now() - t1

print 'Mongodb select elapse :',dt

注：MySQL和mongodb都在locahost上。

MySQL和mongodb都有“key”列索引

MySQL表：CREATE TABLE IF NOT EXISTS `key_val_tab` (

`k` varchar(24) NOT NULL,

`v` varchar(24) NOT NULL,

KEY `kindex` (`k`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

版本包括：MySQL:5.1.41版本

mongodb:1.8.3版

Python：2.6.5

皮蒙戈：2.0.1

Linux:Ubuntu2.6.32Bits和PAE

硬件：桌面核心i7 2.93 Ghz

结果(100万次插入/选择)：MySQL insert elapse : 0:02:52.143803

MySQL select elapse : 0:04:43.675914

Mongodb insert elapse : 0:00:49.038416 -> mongodb much faster for insert

Mongodb select elapse : 0:05:10.409025 -> ...but slower for quering (thought was the opposite)