- 积分
- 117
- UID
- 18397
- 阅读权限
- 20
- 注册时间
- 2015-4-23
- 精华
- 在线时间
- 小时
- 最后登录
- 1970-1-1
- 职业
- 1
|
请问各位大神,我用mysql关联查询,limit进行分页 ,但是当数据过万时翻页就特别慢,请问有什么好的优化办法啊?
我的代码:
SELECT
c0.c_custnum AS cCustnum,
c0.c_username AS cUsername,
c10.cust_rank AS custRank,
jifen30.rank_name AS rankName,
c10.c_accdate AS cAccdate,
c10.c_custname AS cCustname
FROM
capf00 AS c0
LEFT JOIN capf10 AS c10 ON c0.c_custnum = c10.c_custnum
LEFT JOIN capf30 AS c30 ON (c10.c_custnum = c30.c_custnum AND c30.is_del = 'N')
LEFT JOIN capf120 ON capf120.cust_no = c10.c_custnum
LEFT JOIN jifen30 ON c10.cust_rank = jifen30.cust_rank
LEFT JOIN capf101 ON capf101.cust_no = c0.c_custnum
WHERE
capf120.create_time IS NULL
AND c0.is_del = 'N'
AND c10.is_del = 'N'
LIMIT 9500 OFFSET 10
|
|