Good to know it's working, but shame about the speed hit - do you have a database index on the foreign key?
-- Pat On 03/06/2009, at 11:32 AM, tilt wrote: > > Ok, > > switched to filtering via category ids. Good results but results in > 25% increased request processing times. But still fast as hell. > > Btw, fantastic plugin for a fantastic search engine!!! > > On 3 Jun., 10:07, tilt <[email protected]> wrote: >> Thanks for the advice! >> >> That would solve the problem. We're using the permalink instead to >> avoid gathering subcategories recursively. I didn't measure the query >> times but I think this is faster than searching products for each >> subcategory - and the code looks much nicer. >> >> Well, I think there's no way to make Sphinx use delta in a product >> search if changes only occured to the category names. This wouldn't >> be >> very efficient anyway as the delta index would have to be used in >> each >> product search then. >> >> We'll use our old code then... >> >> Best regards >> >> On 3 Jun., 04:54, Pat Allan <[email protected]> wrote: >> >>> It sounds like category is an association for Product. Why not >>> filter >>> by the id instead, to ensure it's always correct? >>> define_index do >>> # ... >>> has category(:id), :as => :category_id >>> end >> >>> Product.search :with => {:category_id => @category.id} >> >>> -- >>> Pat >> >>> On 02/06/2009, at 11:59 AM, tilt wrote: >> >>>> Hi, >> >>>> Is there a way to select an older version of a record even if I've >>>> activated the delta property? >> >>>> We've got the following problem: >> >>>> We'd like to select products filtered by a certain category using >>>> the >>>> permalink of the category. >>>> If the category name is updated and thus its permalink, the >>>> filtering >>>> Product.search :conditions => {:category => permalink} fails >>>> because >>>> the condition tries to match the former permalink of the category. >>>> Unfortunately Sphinx only uses the delta index of the model the >>>> query >>>> is perfomed on, e.g. "Product". >> >>>> So if we can't tell Sphinx to use the delta index for categories >>>> although they only appear within the conditions we apply to search >>>> products, we'll have to tell Sphinx to look up the former >>>> category's >>>> name - ignoring the delta index. >> >>>> Any ideas? >> >>>> Thanks a lot!!! > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en -~----------~----~----~----~------~----~------~--~---
