sid wrote: > After a lot of investigation we were advised to use persistent > connections to sphinx ... because our main bottleneck is IO > contention. i.e. one connection per query. Unfortunately we couldn't > get riddle to start up a persistent connection. We tried caching the > socket it was spawning in a class variable, but the second time Riddle > tries to contact sphinx we get a "sphinx is not responding error" > which I think is sphinx killing the connection on it's end.
The PHP API for sphinx 0.9.9 (but not 0.9.8) seems to support persistent connections (see sections 6.8 in the docs at http://www.sphinxsearch.com/docs/current.html). Looking at line 1544 of api/sphinxapi.php, it looks like a flag needs to be set to enable this option when riddle connects to the daemon. I'm not particularly familiar with riddle, but the list of commands on line 32 of riddle/client.rb doesn't seem to include SEARCHD_COMMAND_PERSIST. You might need to develop a patch to include persistent connection support. -- James Healy <jimmy-at-deefa-dot-com> Thu, 16 Jul 2009 22:42:55 +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 -~----------~----~----~----~------~----~------~--~---
