mysql handler_mysql handler与select 性能比对

mysql> create table test(id int AUTO_INCREMENT PRIMARY KEY NOT NULL,value varchar(100) NOT NULL);

Description:

'''

import random

from time import time

import oursql

class handler:

def __init__(self):

pass

def build_conn(self):

self.conn = oursql.connect(host = 'localhost',

user = 'root',

passwd = '',

db = 'test'

)

def reconnect(self):

try:

self.conn.ping()

except:

try:

self.conn.close()

except:

pass

finally:

self.build_conn()

def open(self):

self.build_conn()

def close(self):

self.conn.close()

def handler(self):

"""docstring for handler"""

self.reconnect()

cursor = self.conn.cursor()

query = 'handler test read first'

cursor.execute(query)

cursor.close()

def table_open(self):

"""docstring for table_open"""

self.reconnect()

cursor = self.conn.cursor()

query = 'handler test open'

cursor.execute(query)

cursor.close()

def table_close(self):

"""docstring for table_close"""

self.reconnect()

cursor = self.conn.cursor()

query = 'handler test close'

cursor.execute(query)

cursor.close()

def table_handler(self):

"""docstring for table_select"""

self.reconnect()

self.table_open()

start=time()

for i in range(0,10000):

cursor = self.conn.cursor()

query = 'handler test read id = (%s) '%(i,)

cursor.execute(query)

res = cursor.fetchone()

cursor.close()

end=time()

print end-start

self.table_close()

return res

def table_select(self):

"""docstring for table_select"""

self.reconnect()

start=time()

for i in range(10000,20000):

cursor = self.conn.cursor()

query = 'select * from test where id = (%s) '%(i,)

cursor.execute(query)

res = cursor.fetchone()

cursor.close()

end=time()

print end-start

return res

def table_insert(self):

"""docstring for table_insert"""

self.reconnect()

for i in range(20000):

cursor = self.conn.cursor()

value = random.randint(0,10000)

query = 'insert into test(value) values(%s)'%(value,)

print query

cursor.execute(query)

cursor.close()

self.conn.commit()

if __name__ == '__main__':

test = handler()

test.open()

test.table_handler()

test.table_select()

test.close()

└─(17:46:%)── python handler.py ──(Thu,Oct27)─┘

1.2317969799 handler的结果

1.61981511116 select的结果

分享到：

2011-10-27 17:47

浏览 1140

分类:数据库

评论