You can enable readOnly attribute value true for the page it will increase Number of query rows from 50000 to 1 million rows and Number of records displayed on VF page will be increased from 1000 to 10000. You can go for pagination which has to limit.