Thursday, January 26, 2012
On Thu, Jan 26, 2012 at 8:51 PM, Linus Pettersson <linus.pettersson@gmail.com> wrote:
-- This query is only to get the appropriate Categories & Subcategories. There are 5 Categories and 45 Subcategories.My products are imported from webshops which are using different categories for the same things ("tshirt", "t-shirts", "t-shirt", "short sleeved shirts" may all be the same). To cope with this issue I have the "Resellercategories" that I relate to a specific Category and Subcategory.Category/Subcategory -> Resellercategory -> Product(Resellercategories are never seen in the frontend)If I filter the products for "male" I only want to display (non-empty) Categories/Subcategories that have male products.To answer your question, there is no pagination on the Categories and Subcategories that I'm fetching here with this query. The query only returns the appropriate Categories/Subcategories. So if filtered by "male" it returns 3 Categories and 12 Subcategories (In my dev environment).
OK, I understand (small amount of categories, much more products).
If you find no other way, then the caching the "has_male_products" etc
in the Category/Subcategory may be the best remaining way.
I was also thinking, maybe it is acceptable that the set of Categories
with "male_products" etc. is only update every hour or so. That would
avoid the complexity of real-time update of that cache column. On the
other hand, an after_save on products is not _that_ difficult.
Just as a test, does your performance improve significantly if you add
a "has_male_products" column on categories and filter on that?
HTH,
Peter
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment