MySQL分页查询及优化

        int totalRows= "select count(id) from PersonInfo";

 

        int start = 0;

        int rows =pageSize;

        int left =totalRows;

        while (start < totalRows) {

            if (rows > left) {

                rows = left;

            }

            logger.info("start = " + start +", rows = "+ rows + ", left = " + left);

           

            List<PersonInfo> personInfoList=

            "SELECT * FROM PersonInfo limit#{start}, #{rows}";

            "SELECT * FROM PersonInfo whereid >= (SELECT id FROM PersonInfo ORDER BY id LIMIT #{start}, 1) limit #{rows}";(查询优化)

           

            start += rows;

            left -= rows;

       }