Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Rails: Prevent will_paginate from calling #count of ActiveRelation

When I pass will_paginate an ActiveRelation, it always calls its #count method and hits the database to find out the total number of items. But this operation takes time and I have the total number already cached and ready. Can I pass this pre-calculated count to will_paginate and stop it from hitting the database?

I tried the :count option, but it is passed to ActiveRecord as an option:

active_relation.paginate(page: 2, per_page: 100, count: total_count)

Thanks! :)

like image 801
sina Avatar asked Nov 02 '14 06:11

sina


1 Answers

Passing the cached count with :total_entries solves the problem:

active_relation.paginate(page: 2, per_page: 100, total_entries: total_count)
like image 171
sina Avatar answered Sep 25 '22 07:09

sina