pymysql和sqlalchemy orm 查询数据时间差异
like模糊查询200万数据,sqlalchemy orm的是pymysql耗时的3.7倍
应该是orm底层对数据格式进行了一层封装导致耗时
t = time.time()
result = db.session.query(SysUsers).filter(getattr(SysUsers, ‘email’).like("%{}%".format(‘xxx’))).all()
print(len(result))
r = str(time.time() - t)[:10]
print®
耗时
1335.35270
ql_cursor = Mysql(‘49...160’, ‘’, ‘’, ‘elog’)
t = time.time()
sql = (“select * from users where email like ‘%{}%’;”.format(‘xxx’))
res = sql_cursor.mysql_select(sql)
print(len(res))
r = str(time.time() - t)[:10]
print®
耗时
353.516909
ORM 返回数据类型