Sounds like you're using MySQL, which by default limits concatenated strings to 1024 characters. You can change this, though:
http://freelancing-god.github.com/ts/en/common_issues.html#mysql_large_fields If that doesn't fix things, let me know :) -- Pat On 22/06/2010, at 10:52 PM, Al-Faisal El-Dajani wrote: > Hello all, > > I have a user table with the following index: > > define_index do > indexes name, :sortable => true > indexes gender > indexes [addresses.area, addresses.street_address], :as > => :address > indexes addresses.city > end > > Now, a user might have multiple addresses. What I noticed is that any > user with a lot of addresses (about 7+), searching for some addresses > does not return the user. > > For instance, I have a pharmacy with 54 branches (addresses). If i > search for an address within the first 9 addresses, i get this > pharmacy in the result, but if I search for any other address value, > this pharmacy does not appear. > I tried deleting some branches, reindexing, and searching again, and > now some addresses that didn't show a result the first time are now > appearing correctly. > > So my question is: is there some kind of limitation on how big an > association can be? is there a way to manipulate this through > configuration? > > Thanx > > -- > 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. > -- 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.
