Hi C Wilson, TS is setup pretty well to handle geo/spatial. There's a bit of a learning curve, but once you're familiar with everything and have things optimized Sphinx will handle it as just another piece of data to filter on.
We basically use it as a geo/spacial caching layer in front of MySQL querying 5+ million records with many filters. If I had to do it again I would probably use PostgreSQL with Sphinx or ElasticSearch. Main things to think about. - Sphinx requires that your lat/lng are stored in radians (in the index). - You can create a geospatial index by breaking the world up into a grid and add those grids to your index, then query against those specific grids. You'll find a lot just by googling, but I'd be happy to pass on some examples of what we've done. On Mon, Aug 19, 2013 at 12:45 PM, C Wilson <[email protected]> wrote: > I am curious if using TS would be a good fit for doing some geo/spatial > search? I have a social app and would need for users to be able to find > other users based on distance. So User A could be browsing the advanced > search options and chose to find other users who are x amount of miles from > a zip code. How well can TS function? I am sure lagitude and longitude > would have to be provided along with the US zip code database. I have that > information which would result into 127,569 data entries importing to the > database since there's 42,523 zip codes. > > I guess my concern is can TS handle that much data from zip code > information alone? How will it affect the performance of the website and > esentially load time of search results for the user. Having TS search from > 127k columns sounds like a lot of processing. > > -- > 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. > -- twitter.com/teddyg www.foodspotting.com http://itunes.apple.com/us/app/foodspotting/id350727118?mt=8 -- 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.
