> Thinking Sphinx does *not* query the sphinx daemon for IDs using SQL, so > you will never see an SQL log fom that query.
Ah, that was the bit I was missing. That clears it up. Thanks. /g On Jul 21, 1:58 am, James Healy <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
