Server issue [Registered members] page is very slow when going to specific page on website has 500K+ members

[Doku]

When members of a site are large enough(about 500K+). It is very slow to go to specific page in [Registered members] page.
For example: http://www.tinhte.vn/members/?page=60151
MySQL query took 50s+ to respond.

 

[Doku]

If this bug can not be fixed soon, somebody please instruct me how to disable [Registered members] page. Thanks a lot.

 

[guiltar]

That is not a bug but MySQL pagination performance problem.
MySQL does full scan of the whole table to show last page.
Here are some resources for devs that may help to avoid it.
http://www.ovaistariq.net/404/mysql...ll-performance-vs-how-to-improve-performance/
http://www.slideshare.net/suratbhati/efficient-pagination-using-mysql-6187107

The simplest solution to exclude the members page is to remove the link on it. But users still can visit the page by url.