Have a look at the charset_table and ignore_chars options - the hyphen character is actually mentioned as an example in the latter: http://www.sphinxsearch.com/docs/manual-0.9.8.html#conf-charset-table
And then you can set both of those via config/sphinx.yml http://freelancing-god.github.com/ts/en/advanced_config.html Cheers -- Pat On 04/06/2009, at 5:35 AM, tilt wrote: > > Not yet, in fact we haven't done any tuning yet. Perhaps by indexing > the categories_products join table we'll gain some extra speed. > > I've got another - hopefully last - question google and me weren't > able to answer. > Is it possible to turn off the "-" operator in a Sphinx search or to > force an exact match? (This one has nothing to do with the subject of > this thread, sorry for appending it here) > > gods.com> wrote: >> 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 -~----------~----~----~----~------~----~------~--~---
