- 注册时间
- 2017-7-12
- 最后登录
- 1970-1-1
- 阅读权限
- 10
- 积分
- 99
- 精华
- 0
- 帖子
- 0
|
今天测试了12w行数据,11秒读取出来的,当然卡顿是正常了,毕竟这么多数据
所以想问问工程师,这个问题通常怎么解决?
我看了其他帖子,一般都是用虚拟滚动,但是我还是想要这个datagrid的ui效果。。。。。
下面是我后台获取数据的方法
试过用单独查询某字段方式,读取速度也是一样的。。。。
public function spec_list_data(){
$key = I('request.key');
$index = I('request.pageIndex');
$size = I('request.pageSize');
//$sortField = I('request.sortField');
//$sortOrder = I('request.sortOrder');
$myconn = M('spec_testinfo');
if ($key==null) {
//$countresult = $myconn->select();
$datacount = $myconn->count();
$total = $datacount;
$start = $index * $size;
if(!empty($sortField)){
if ($sortOrder != "desc") $sortOrder = "asc";
$order = " order by " . $sortField . " " . $sortOrder;
} else {
$order = " order by date desc";
}
//$field='cb,bid,icid,daid,spec_status,eq_status,yushen_status,pd_status,apqpstatus,date,cp_status,byuser';
$dataresult = $myconn->order('date desc')->limit($start,$size)->select();
$resultData = array("total"=>$total,"data"=>$dataresult);
$rss = json_encode($resultData);
echo $rss;
|
|