Hi there, from my code hunting and general searching I've pretty much determined that thinking sphinx doesn't support indexing the same models across a series of databases.
I have a CMS app and each clients data is stored in a separate database for many reasons. When the rails app gets a connection it looks at the hostname requested and switches databases accordingly. It all works quote well except when it comes to search. I managed to get Ferret to work with multiple databases by adding another key which was the database name to the ferret index. I also had someone hack ultrasphinx so that it would encode the database in the upper digits of the sphinx index. I've decided to make the switch to thinking sphinx because the setup for ultrasphinx is both complicated and fails quite a lot (well the indexer does anyway). Can someone point me in the right direction with regards to modifying thinking sphinx to work with multiple databases? From what I can tell most of the changes would be in the configuration.rb file where code would have to be added to loop both databases and models and index them appropriately. Any tips would be greatly appreciated, and I would seriously consider paying to get it added as an official feature of thinking sphinx. Looking forward to hearing from you :) Brendon --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
