在大数据量下有什么分页方法？LIMIT效率不高

0 0

10 years, 2 months ago

RadMK2 10 years, 2 months ago

上sphinx ...

answered 10 years, 2 months ago

哎哟啊van answered 10 years, 2 months ago

把数据缓存下来吧，或许应该考虑一下重构数据库结构了

answered 10 years, 2 months ago

　李宇春　 answered 10 years, 2 months ago

$sql = "select *from user where id>{$id} limit 10";$id为上一页最大的值

answered 10 years, 2 months ago

会说话的老妖精 answered 10 years, 2 months ago