Pat, That was right on the money. Many thanks :)
On Jun 22, 4:51 pm, Pat Allan <[email protected]> wrote: > 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_larg... > > 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 > > athttp://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.
