利用数据库偏移分页进行优化:
import math
import db
def test():
queryset = biaoming.query.filter_by(validbook=1).order_by(biaoming.id.desc())
all_page = int(math.ceil(queryset.count() / 30.0))
result = []
for q in queryset.offset(int(page - 1) * 30).limit(30):
result.append(q.to_dict)
return jsonfy({''data'':result})
class biaoming(db.Model):
id = db.Column(db.Integer,Primary_key=True)
def to_dict(self):
tablename = self.__tablename__
table = self.metadata.tables[tablename]
ret = {}
ret['id'] = getattr(self, 'id')
return ret