Hello there,
I'm looking to get sphinx and thinking-sphinx integrated into my site.
However, I've run into a weird problem.
The first search takes just under 400 seconds. Subsequent searches are
fast. For example:
irb> Benchmark.realtime { Product.search("Monday") }
> (398699.9ms) SELECT DISTINCT collection_type FROM products WHERE
> collection_type IS NOT NULL
> => 398.756526954
> irb> Benchmark.realtime { Product.search("Monday") }
> => 0.000110899
Connections using Riddle appear to be instant (After starting a new rails
console):
irb> client = Riddle::Client.new 'sphinxhost.blah.com', 9312
> => #<Riddle::Client:0xb1c9d7c @servers=["sphinxhost.blah.com"],
> @port=9312, @socket=nil, @key=nil, @offset=0, @limit=20, @max_matches=1000,
> @match_mode=:all, @sort_mode=:relevance, @sort_by="", @weights=[],
> @id_range=0..0, @filters=[], @group_by="", @group_function=:day,
> @group_clause="@weight DESC", @group_distinct="", @cut_off=0,
> @retry_count=0, @retry_delay=0, @anchor={}, @index_weights={},
> @rank_mode=:proximity_bm25, @rank_expr="", @max_query_time=0,
> @field_weights={}, @timeout=0, @overrides={}, @select="*", @queue=[]>
> irb> Benchmark.realtime { client.query('Monday') }
> => 0.067847711
Telnetting to the sphinx host is immediately connected - although I haven't
tried a query through that interface.
Any thoughts on why the first connection is so slow? It looks like some
kind of timeout to me - but I can't see what. DNS queries both forward and
reverse are fast.
I'm using a main + delta setup with deltas being updated every 20 minutes
and merged every 20 minutes ( offset from the updates by 10 minutes).
I'm running seachd from init because I don't like to run long running
processes as a user (init will restart failed processes). I symlink
/etc/sphinxsearch/sphinx.conf to my thinking-sphinx generated
configuration. I don't think this is related though, as searches do
eventually work.
Cheers,
Dan
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/thinking-sphinx/-/gJFa7kX9QC0J.
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.
