Hi Thibault
Can you add the following option to each of the attributes you've defined:
:source => :query - and see if that helps?
Also: in TS v3, delta options are specified alongside :with => :active_record:
ThinkingSphinx::Index.define :card, :with => :active_record, :delta => true do
# ...
end
--
Pat
On 4 Feb 2014, at 8:11 pm, Thibault Clavel <[email protected]> wrote:
> Hi everyone,
>
> I've set up TS 3.1.0 on a rails 4 app, which is what I would call a "playing
> card manager".
>
> Here is my Card index :
>
> ThinkingSphinx::Index.define :card, :with => :active_record do
> # fields
> indexes name, :sortable => true
> indexes name_en, :sortable => true
>
> has colors(:id), :as => :color_ids
> has card_formats(:id), :as => :card_format_ids
> has rarities(:id), :as => :rarity_ids
>
>
> set_property :delta => true
> end
>
>
> Colors, Card Formats and Raritiers are all has_many through relationships
> with the Card model. When I run rake ts:rebuild or ts;index, it takes less
> than a minute to proceed.
>
> If I add this line :
>
> has card_types(:id), :as => :card_type_ids
>
> ... which is another has_many :through, indexing starts ("indexing
> card_core") but seems to get stuck at this point. Last stime I let it run for
> almost 20h with no progress. :(
>
> If I run SHOW INDEX on the join table card_card_types, I get this :
>
> mysql> SHOW INDEX FROM card_card_types;
> +-----------------+------------+---------------------------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
> | Table | Non_unique | Key_name |
> Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed |
> Null | Index_type | Comment | Index_comment |
> +-----------------+------------+---------------------------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
> | card_card_types | 0 | PRIMARY |
> 1 | id | A | 25550 | NULL | NULL | |
> BTREE | | |
> | card_card_types | 1 | index_card_card_types_on_card_id |
> 1 | card_id | A | 25550 | NULL | NULL | YES |
> BTREE | | |
> | card_card_types | 1 | index_card_card_types_on_card_type_id |
> 1 | card_type_id | A | 34 | NULL | NULL | YES |
> BTREE | | |
> +-----------------+------------+---------------------------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
>
> which seems OK to me, since card_id and card_type_id are indexes.
>
> Any thoughts about this ?
>
> Thanks a lot !
>
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Thinking Sphinx" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/thinking-sphinx.
> For more options, visit https://groups.google.com/groups/opt_out.
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/thinking-sphinx.
For more options, visit https://groups.google.com/groups/opt_out.
