Question

Django Web开发 ，我有一个很简单的查询，可数据有几十万条，查询出来很慢，我有分页，怎么提高效率问题

def adminSamplelist(request):
RulelistAll = RuleList.objects.order_by('rule_id').filter(querylist).all()
if request.GET.get('export') == '1':
return Export_syslog(querylist)
after_range_num = 2
before_range_num = 9
try:
page = int(request.GET.get('page',1))
if page < 1:
page = 1
except ValueError:
page = 1
paginator = Paginator(RulelistAll,12)
try:
RulelistAllList = paginator.page(page)
except(EmptyPage,InvalidPage,PageNotAnInteger):
RulelistAllList = paginator.page(1)
for date in RulelistAllList.object_list:
date['lastupdate'] = str(date['lastupdate'])[:10]
if page >= after_range_num:
page_range = paginator.page_range[page - after_range_num:page + before_range_num]
else:
page_range = paginator.page_range[0:int(page) + before_range_num]
return render_to_response('Rule_list.html', locals())

Answer 1

dim rs as adodb.recordset
dim conn as adodb.connection //must open conn before the form show
dim sqlstr as string

sqlstr = "select * from table"
set rs = conn.execute(sqlstr)

if rs.eof then exit sub

grid.rows = grid.rows +1

grid.textmatirs(grid.rows-1,1) = rs.fields(0)
grid.textmatirs(grid.rows-1,2) = rs.fields(1)
......
grid.textmatirs(grid.rows-1,n) = rs.fields(n)

我不知道你要查询的记录集有几个字段，所以用n表示。
懂了吗？

追问

我没明白你这是什么意思，Django框架中，我没有写Sql语句的，请在我的那个查询View里面改，感谢

Answer 2

.........................

Answer 3

不懂哦

Answer 4

把你分页的查询语句发上来。

追问

出来了？帮忙看看吧

追答

建议你在数据库中分页。