Hi Pat - Once I remove the WHERE clause, what should I do next to determine this? On Dec 3, 2011, at 11:25 AM, Pat Allan wrote:
> Have a look at config/development.sphinx.conf, and the sql_query for the > address_core_0 source. Remove the id and delta parts of the WHERE clause > (which probably means the entire WHERE clause) and see if you can figure out > why we're getting 223 results for 49 addresses. > > On 03/12/2011, at 11:07 PM, Manish M. Shah wrote: > >> Hm, not fully sure how the indexer works on the back end, but if it helps, >> each listing can have up to 3 addresses and up to 3 categories ... does that >> help explain? >> >> On Dec 3, 2011, at 10:58 AM, Manish M. Shah wrote: >> >>> All addresses have at least a location (city/country/postal/etc) and each >>> does have at least one listing. >>> >>> Heres the output: >>> >>> DEPRECATION WARNING: Rake tasks in vendor/plugins/thinking-sphinx/tasks are >>> deprecated. Use lib/tasks instead. (called from >>> /Library/Ruby/Gems/1.8/gems/rails-2.3.11/lib/tasks/rails.rb:10) >>> Stopped search daemon (pid 917). >>> Generating Configuration to >>> /Users/manish/AcceleWeb/srcror/getmethe.com/config/development.sphinx.conf >>> Sphinx 0.9.9-release (r2117) >>> Copyright (c) 2001-2009, Andrew Aksyonoff >>> >>> using config file >>> '/Users/manish/AcceleWeb/srcror/getmethe.com/config/development.sphinx.conf'... >>> indexing index 'address_core'... >>> collected 223 docs, 0.0 MB >>> sorted 0.0 Mhits, 100.0% done >>> total 223 docs, 5027 bytes >>> total 0.155 sec, 32263 bytes/sec, 1431.23 docs/sec >>> indexing index 'address_delta'... >>> collected 0 docs, 0.0 MB >>> total 0 docs, 0 bytes >>> total 0.037 sec, 0 bytes/sec, 0.00 docs/sec >>> distributed index 'address' can not be directly indexed; skipping. >>> total 5 reads, 0.000 sec, 16.8 kb/call avg, 0.1 msec/call avg >>> total 14 writes, 0.000 sec, 14.3 kb/call avg, 0.0 msec/call avg >>> Started successfully (pid 2838). >>> >>> On Dec 3, 2011, at 10:54 AM, Pat Allan wrote: >>> >>>> Right, well it's likely this is the bigger issue. Do all addresses have a >>>> city? And do all have at least one listing? What's the output when you run >>>> the ts:index rake task? >>>> >>>> -- >>>> Pat >>>> >>>> On 03/12/2011, at 10:43 PM, Manish M. Shah wrote: >>>> >>>>> There should be - but it's not returning all of them :( >>>>> >>>>> On Dec 3, 2011, at 10:36 AM, Pat Allan wrote: >>>>> >>>>>> Wait, there's 49 addresses, but only 11 get returned if you don't use a >>>>>> geo point? Surely there should be a full page of 20? >>>>>> >>>>>> -- >>>>>> Pat >>>>>> >>>>>> On 03/12/2011, at 10:32 PM, Manish M. Shah wrote: >>>>>> >>>>>>> >>>>>>> I have 49 total addresses and 15 don't have valid lat/lng values (they >>>>>>> are null). >>>>>>> >>>>>>> For those that are null, at least from an app perspective, this is fine >>>>>>> - but could that be causing Sphinx to get confused? >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Dec 3, 2011, at 6:39 AM, Pat Allan wrote: >>>>>>> >>>>>>>> Right, well it seems Sphinx is doing something odd when you supply >>>>>>>> co-ordinates then, even through you're not filtering on geodist. Do >>>>>>>> all Addresses have valid lat/lng values? >>>>>>>> >>>>>>>> -- >>>>>>>> Pat >>>>>>>> >>>>>>>> On 02/12/2011, at 7:42 PM, Manish M. Shah wrote: >>>>>>>> >>>>>>>>> That's correct, this is the version I use if no lat/lng is set : >>>>>>>>> @addresses = Address.search :order => :listing_created_at, :sort_mode >>>>>>>>> => :desc >>>>>>>>> >>>>>>>>> It returns 11 results. >>>>>>>>> >>>>>>>>> >>>>>>>>> On Dec 2, 2011, at 4:47 AM, Pat Allan wrote: >>>>>>>>> >>>>>>>>>> Hm, and if you search with no arguments, you get a full paginated >>>>>>>>>> set of results, right? >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> Pat >>>>>>>>>> >>>>>>>>>> On 02/12/2011, at 11:53 AM, Manish M. Shah wrote: >>>>>>>>>> >>>>>>>>>>> Ahh :) >>>>>>>>>>> >>>>>>>>>>> I got rid of has latitude, longitude and reindexed and got 2 items >>>>>>>>>>> for SF and 4 items for NY :< >>>>>>>>>>> >>>>>>>>>>> Manish >>>>>>>>>>> >>>>>>>>>>> On Dec 1, 2011, at 11:49 PM, Pat Allan wrote: >>>>>>>>>>> >>>>>>>>>>>> Sorry, just to confirm - you want to keep the radians attributes, >>>>>>>>>>>> but remove the ones that aren't in radians. So, keep these: >>>>>>>>>>>> has "RADIANS(latitude)", :as => :lat, :type => :float >>>>>>>>>>>> has "RADIANS(longitude)", :as => :lng, :type => :float >>>>>>>>>>>> >>>>>>>>>>>> But remove this: >>>>>>>>>>>> has latitude, longitude >>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>>> Pat >>>>>>>>>>>> >>>>>>>>>>>> On 02/12/2011, at 11:43 AM, Manish M. Shah wrote: >>>>>>>>>>>> >>>>>>>>>>>>> Without Radians - it returns 1 result for Chicago and 5 results >>>>>>>>>>>>> for San Francisco, much less then db has. >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> On Dec 1, 2011, at 11:38 PM, Pat Allan wrote: >>>>>>>>>>>>> >>>>>>>>>>>>>> Is it any better if you don't have the non-radians latitude and >>>>>>>>>>>>>> longitude attributes? >>>>>>>>>>>>>> >>>>>>>>>>>>>> -- >>>>>>>>>>>>>> Pat >>>>>>>>>>>>>> >>>>>>>>>>>>>> On 02/12/2011, at 11:35 AM, Manish M. Shah wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>>> Hi Path, >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Thanks for helping - >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> define_index looks like this in Address model: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> define_index do >>>>>>>>>>>>>>> has latitude, longitude >>>>>>>>>>>>>>> has "RADIANS(latitude)", :as => :lat, :type => :float >>>>>>>>>>>>>>> has "RADIANS(longitude)", :as => :lng, :type => :float >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> indexes city >>>>>>>>>>>>>>> indexes listings.title, :as => :listing_title >>>>>>>>>>>>>>> indexes listings.description, :as => :listing_description >>>>>>>>>>>>>>> indexes listings.categories.name, :as => :category_names >>>>>>>>>>>>>>> indexes listings.created_at, :as => :listing_created_at, >>>>>>>>>>>>>>> :sortable => true >>>>>>>>>>>>>>> set_property :delta => true >>>>>>>>>>>>>>> end >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> That's the full query I'm running. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> On Dec 1, 2011, at 11:31 PM, Pat Allan wrote: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Is that the entire search query you're running? There's no >>>>>>>>>>>>>>>> keywords or distance filters? >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Also, what does your define_index block look like for the >>>>>>>>>>>>>>>> Address model? >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>>> Pat >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> On 02/12/2011, at 11:24 AM, mrmanishs wrote: >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> When I do a: >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> @addresses = Address.search :geo => [@lat, @lng], :order => >>>>>>>>>>>>>>>>> "@geodist >>>>>>>>>>>>>>>>> ASC, @relevance DESC" >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> I only get 4 results back. I know for a fact that I have a >>>>>>>>>>>>>>>>> lot more >>>>>>>>>>>>>>>>> addresses available with further geo-distances then the 4 >>>>>>>>>>>>>>>>> returned >>>>>>>>>>>>>>>>> when I select the city of Chicago >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> However, for the city of San Francisco, I only get 2. >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> Is there a configuration that tells geo search to return only >>>>>>>>>>>>>>>>> a >>>>>>>>>>>>>>>>> certain distance away, or is there a default set? >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> I can't figure out what's going on... >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>>>> 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. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>> 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. >>>>>>>>>>>>> >>>>>>>>>>>>> -- >>>>>>>>>>>>> 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. >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> 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. >>>>>>>>> >>>>>>>>> -- >>>>>>>>> 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. >>>>>>> >>>>>>> -- >>>>>>> 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. >>>>> >>>>> -- >>>>> 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. >>> >>> -- >>> 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. >> > > -- > 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.
