Thinking Sphinx

Hi,

I am having problem in searching the results. If the foreign key store_id in the orders table is greater than 999, then returns the empty results. But it returns the correct result set when the its <=999.

How to make it working when the store_id is greater than 999?

Hi there

I'm not quite sure what the problem is by your description - I'm guessing you're searching on the Order model? What's the index definition for Order? And what's the query you're running that isn't working as you expect?

Also: for future reference, it's better to ask Thinking Sphinx questions on the Thinking Sphinx google group: http://groups.google.com/group/thinking-sphinx

Cheers

Hi Pat,

Thanks for your response, will post the request on the google group.

Regards, Raghu

Raghu 2009 wrote in post #968477:

Hi Pat,

Thanks for your response, will post the request on the google group.

Regards, Raghu

if you have a sphinx.yml file there is something called "max_matches: 100000".try that

development:     bin_path: "/usr/local/bin"     enable_star: true     morphology: libstemmer_en     match_mode: any     min_infix_len: 2     min_prefix_len: 2     max_matches: 100000     port: 3310