测试mysql长连接和短连接直接在tornado下的性能问题

test_long.py

import tornado.ioloop
import tornado.web
import MySQLdb

def get_conn():
    db = MySQLdb.connect("localhost","alex","1qasw2","test")
    #db.autocommit(False)
    return db

def query(db):
    cursor=db.cursor()
    cursor.execute("select * from test_user where id = 1")
    result=cursor.fetchall()
    cursor.close()
    if result:
        return result
db=get_conn()

class MainHandler(tornado.web.RequestHandler):
    def get(self):
        query(db)
        self.write("Hello, world")

application = tornado.web.Application([
    (r"/", MainHandler),
])

if __name__ == "__main__":
    application.listen(6666)
    tornado.ioloop.IOLoop.instance().start()

test_short.py

import tornado.ioloop
import tornado.web
import MySQLdb

def get_conn():
    db = MySQLdb.connect("localhost","alex","1qasw2","test")
    #db.autocommit(False)
    return db

def query(db):
    cursor=db.cursor()
    cursor.execute("select * from test_user where id = 1")
    result=cursor.fetchall()
    cursor.close()
    if result:
        return result

class MainHandler(tornado.web.RequestHandler):
    def get(self):
        db=get_conn()
        query(db)
        db.close()
        self.write("Hello, world")

application = tornado.web.Application([
    (r"/", MainHandler),
])

if __name__ == "__main__":
    application.listen(6666)
    tornado.ioloop.IOLoop.instance().start()