Thinking Sphinx will update attributes if they are integers, booleans
or timestamps if they are the only values that have changed (ie: no
fields, float, MVA or custom-sql attributes). So it looks like it's
updating both the core and delta index with that information in this
case.
That doesn't answer why the filter isn't working, though.
How are you handling deletions? Are you overwriting destroy? Also,
what versions of TS, Sphinx and Rails are you using?
How long are you waiting to test the search after updating that
attribute? Sphinx may take a second or two for the changes to kick in
(depends on how powerful the machine is, spare memory, etc).
--
Pat
On 02/09/2009, at 11:01 PM, monkeyten wrote:
>
> I seem to have a strange problem with my delta indexes and filtering
> on attributes which I hope someone can shed some light on.
>
> In my model there is a deleted attribute (a boolean field). Searching
> on a fresh (full) index will correctly only return results with
> deleted = 0 if I use :with => {:deleted => 0}. If one of the records
> is then updated (so deleted = 1), it appears as if both the core and
> the delta index are updated (based on the query log - not sure if this
> is the correct interpretation):
>
> [Wed Sep 2 21:59:16.945 2009] 0.000 sec [scan/2/rel 1 (0,20)]
> [item_core]
> [Wed Sep 2 21:59:16.949 2009] 0.000 sec [scan/2/rel 0 (0,20)]
> [item_delta]
> [Wed Sep 2 21:59:16.954 2009] 0.000 sec [scan/2/rel 1 (0,20)]
> [item_core]
>
> Future searches using the same :with filter will however still return
> the object which now has deleted = 1 (unless I do a full reindex).
>
> Can anyone shed any light on the issue?
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
