How to implement pagination on number and alphabet at the same time [CI3]

Pagination on the number of pages but if i want to view data start with K, i click on 'K' and its jump to page 33 which is a page that starting with k letter. How to implement something like this? 

select all data to find the K starting point look waste of resource (because we need to find other 25 letter starting point too) any better way to implement this?

for example: *REDACTED*

I think you will have to do as you say: select all the titles and find the right page number.
But you can cache the result for better performance and not do this at each page load: https://www.codeigniter.com/user_guide/l...ching.html

Also can you please not post porn site as example! 

I think you will have to do as you say: select all the titles and find the right page number.
But you can cache the result for better performance and not do this at each page load: https://www.codeigniter.com/user_guide/l...ching.html

Thank you for your suggestion. and sorry about example link ;-;