sqlalchemy使用count()函数遇到的问题
在使用flask-sqlalchemy对一个千万级别表进行count操作时,出现了耗时严重、内存飙升的问题。
原代码:
# 统计当日登陆次数 count = LoginLog.query.filter(LoginLog.username == username, LoginLog.status == 0, db.cast(LoginLog.time, db.DATE) == db.cast(datetime.utcnow(), db.DATE)).count()
sql打印:
SELECT count(*) AS count_1 FROM ( SELECT loginlog.id AS loginlog_id, loginlog.username AS loginlog_username, loginlog.time AS loginlog_time, loginlog. STATUS AS loginlog_status FROM loginlog