Hi George, Happy to hear you're making progress.
george.anderson wrote: > > > If you want the SQL used when searching should be printed to your > > development.log just after the "Sphinx: " entry. Sphinx only returns > > numeric IDs and then rails does the SQL. > > It's not being logged in development.log. I'm on Rails 2.3.2. > Perhaps I've mis-configured something? The controller code you posted does a search_for_ids() not search(), so rails is not performing a SQL query with your database after sphinx returns its results. > > If you want the SQL sphinx uses to extract data from your DB when > > indexing, it is listed in the Sphinx config file > > (config/development.sphinx.conf). > > searchd.query.log show things like: > > [Tue Jul 21 01:29:47.312 2009] 0.001 sec [ext/2/rel 112 (0,1000000)] > [*] @plan_status sub_grant_agreement_approved > > which is somewhat helpful, but I'm looking for the full SQL query. Thinking Sphinx does *not* query the sphinx daemon for IDs using SQL, so you will never see an SQL log fom that query. -- James Healy <jimmy-at-deefa-dot-com> Tue, 21 Jul 2009 15:54:34 +1000 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
