acts_as_taggable pagination

Recently I needed to paginate the results of find_tagged_with method. I am using the acts_as_taggable plugin.

I did not want to paginate the collection after it has been retrieved since the data set I am working with is huge.

Just for reference, using the paginate_collection function, you'll use something like this to paginate your collection:

q_favorites=Favorite.find_tagged_with(:any => params[:tag], :separator=>',', :order=>'updated_at DESC')
@favorite_pages, @favorites = paginate_collection(:collection=>q_favorites, :page => @params[:page])

So, after looking around (and not finding a solution), I finally decided to go the query way.

Here's my solution based on paginate example in the Wiki. Enjoy:

page = (params[:page] ||= 1).to_i
items_per_page = 3
offset = (page - 1) * items_per_page

@webpage_count = Webpage.count("tags_webpages.tag_id = tags.id AND ( tags.name = 'Accounting' ) AND webpages.id = tags_webpages.webpage_id",
joins = ", tags_webpages, tags")

@webpage_pages = Paginator.new(self, @webpage_count, items_per_page, page)


@webpages=Webpage.find_tagged_with(:any => params[:tag], :limit=>items_per_page, :offset=>offset, :separator=>',', :order=>'updated_at DESC')

If you can think of something better, please post a comment.