RubyFlow The Ruby and Rails community linklog

Find nearby locations in Rails with Oracle 50x faster

by Alex Shi —

By utilizing spatial index, we can largely reduce the table rows scanned while finding nearby locations by given city’s latitude/longitude. See how SQL query is speed up by 50x. https://hlcfan.github.io/find-nearby-locations-in-rails-with-oracle.html

Post a comment

You can use basic HTML markup (e.g. <a>) or Markdown.

As you are not logged in, you will be
directed via GitHub to signup or sign in