Are Sphinx & thinking_sphinx really stable? Not indexing Columns
- by seb
I'm encountering strange behaviour from thinking_sphinx/sphinx.
My define_index block is about 100 lines, so quite a lot of columns i'm indexing. For full-text searching I only need about 10 attributes, for sorting and filtering I have another approximately 50 columns, mostly floats and integers.
By filtering I mean using the "with" or "without" options.
Searching does not really work consistently. All of a sudden, one attribute fails to filter. Or if I add a new one, it does not work. Only after a lot of tinkering it suddenly starts working. I cannot really reproduce it.
Steps I that sometimes lead me to success where:
rm -rf db/sphinx
change the attribute definition
e.g.
has some_attribute
= has some_attribute, :sortable = true
or
= has some_attribute, :sortable = true, :as = "some_attribute"
restarting the server
assigning a new :as name
= has some_attribute, :as = "some_attribute_new"
(yes, I did rake ts:rebuild or rake ts:in after every step)
Does anybody else encounter similar problems?
