Thanks for the links.
The Sphinx storage engine actually creates fake tables - you add some custom parameters and it calls out to the Sphinx searchd process which can be on another box entirely. So you perform a SELECT * WHERE query = 'your search query;your=custom;params=here'; and get back a rowset. Because it operates within MySQL itself you can join at the source to your actual full records. Sphinx itself is somewhat awkward to get running. Performance is stellar, though. Once I deploy my Sphinx wrappers on our high-volume site (mid next week probably), I'll make a post on my blog, if you want to keep an eye on that. Evan Weaver http://blog.evanweaver.com On Feb 26, 5:59 pm, "zdennis" <[EMAIL PROTECTED]> wrote: > On Feb 25, 8:07 pm, "Evan" <[EMAIL PROTECTED]> wrote: > > > has_many_polymorphs (http://blog.evanweaver.com/pages/has_many_polymorphs > > ) use a custom AR association/reflection type now. I am pushing > > towards eliminating the "can't eager load polymorphic associations > > error" for all polymorphic relationships. > > > Also, re. Zach: > > > > - adding query support for regular expressions, and having better > > > - adding block based foreign key enable/disable support > > > Have you made these patches publicly available? > > rubyforge site:http://rubyforge.org/projects/arext/ > official project blog:http://continuousthinking.com/tags/arext > download link:http://rubyforge.org/frs/?group_id=2113 > RDOC:http://continuousthinking.com/tags/arext/rdoc/index.html > (scroll down to the ActiveRecord::Extensions:Regexp.... classes) > > > > > > - adding fulltext index searching support for MySQL > > > I have a Sphinx model for use with the SphinxSE MySQL special engine > > type. It doesn't patch AR though. > > I haven't used Sphinx. Is it alot better then MySQL's builtin support? > > Zach --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" 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/rubyonrails-core?hl=en -~----------~----~----~----~------~----~------~--~---
