Hi, I started looking at sphinx today, with the intent to port an application's search engine from solr to sphinx. The solr implementation is solid, but doesn't meet my business needs - we have to bulk load the database and reindex new data more often than indexing solr takes! It is a huge bottleneck in our ops. I have a few comments which I'd like to share, as well as a couple of questions I hope I can get some guidance with.
Sphinx (and TS) installation was a breeze. First step for me was to try out the indexing speed. I added a few fields and attributes to a Patient model and kicked off indexing. I was discouraged by how long it took. Turns out that the (fake) data I was indexing came from fixtures. Switching to a production-like database, with sequential primary keys, indexed 500K+ records in less than a minute. Wow! Now I have a problem. I've added a DOB attribute (has person.dob, :as => :date_of_birth). Now, when I run the index, it is only picking up 45885 docs (I'm expecting over 500K+). The dob field is of type timestamp. As a trial, I switched person.dob to person.created_at, and all of the 500K+ documents do get generated. Any thoughts on why this is happening? The next challenge is facet support, specifically on associations. Is there a fork somewhere where this has been implemented? Any pointers would be appreciated. Thanks, -H --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
