Hansen1160 |
2015-04-23 14:29 |
如何提高mysql关联查询 分页的查询效率
请问各位大神,我用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 |
|