2009/4/16 fausto <fausto.ga...@email.it> > > 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? > Is there anyone who use shpinx in production? > Another big question about it is if it's possible to create custom > indexes without having the records in the db,
You can send an xml "docset" document to sphinx to build the index; use the xmlpipe2 source type in your conf and have a script that will generate the xml to STDOUT. The docset contains a set of documents with id's (which you might map to the id in a table in your database if you were using it). Each document contains a set of field tags with the information you want to index. I don't know how that squares with large datasets - my app was very small. I use the Riddle client that comes with Thinking Sphinx to talk to searchd. Some of this stuff is documented on the sphinx website somewhere, though piecing it altogether took some effort. -- Daniel Bush http://blog.web17.com.au --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
