On Apr 15, 2009, at 3:59 PM, fausto wrote:
> > Hi, i'm currently using ferret+acts_as_ferret for doing some searches > in the db (not so big for now, just 40k~ records, but they will be > near 2M+ soon). For now ferret it's working quite well, but sometimes > i've indexes corrupted (i use it's drb server in production) and i've > to rebuild all the indexes, so i've bad indexes, angry users and time > spent to make it right. > I'm looking at sphinx and it seems the answers to this problems, as it > seems that it doesn't have this such of problems. But i've seen that > i've to remake indexes everytime (/hour or less).. does it take a lot > to rebuild them? Look into the 'delta' options. That way you have a main index and a delta index of recent changes. Quicker to update and then nightly you can rebuild the whole thing. > Is there anyone who use shpinx in production? I have in the past yes, using the thinking sphinx plugin. Worked great. > Another big question about it is if it's possible to create custom > indexes without having the records in the db, for example with ferret > it's just a :fields => {:my_custom_field => {}} and then a method > named my_custom_field which set what i need (for example a list of > strings/integers, that i need to index, like category ids "4 8 15 16 > 23 42", and then doing a query searching with for example 15, or stuff > like that (actually i've 8 fields, but soon they will be around 12-15) > Is it possible something like this with sphinx? > For ferret there is acts_as_ferret, for sphinx what do you suggest ? > acts_as_sphinx or is there something else? > thank you > > --~--~---------~--~----~------------~-------~--~----~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---