SQL Query for Performing Radius Search based on Latitude Longitude

by

IS THERE ANYTHING WRONG With this
query?

In my opinion the WHERE clause is going to be slow because of the maths involved, and the use of functions in the WHERE clause will prevent the database using an index to speed the query – so, in effect, you will examine every restaurant in the database, and perform the great-circle maths on every row, every time you make a query.

Personally I would calculate the TopLeft and BottomRight co-ordinates of a square (which only needs to be crudly calculated using pythagoras) with sides equal to the range you are looking for, and then perform the more complicated WHERE clause test on the smaller subset of records that are within that Lat/Long square.

With an Index on Lat & Long in the database the query

WHERE     MyLat >= @MinLat AND MyLat <= @MaxLat
      AND MyLong >= @MinLong AND MyLong <= @MaxLong

should be very efficient

(Please note that I have no knowledge of MySQL specifically, only of MS SQL)

More Related Contents:

  1. How to insert utf-8 mb4 character(emoji in ios5) in mysql?
  2. Location Manager Error : (KCLErrorDomain error 0)
  3. Calculate new coordinate x meters and y degree away from one coordinate
  4. Alternatives to google maps api [closed]
  5. Whats the fastest way to lookup big tables for points within radius MySQL (latitude longitude)
  6. Moving a CLLocation by x meters
  7. Forward geocoding from the iPhone
  8. how to get rowNum like column in sqlite IPHONE
  9. Synchronizing an SQLite client database with a MySQL server database
  10. position: fixed doesn’t work on iPad and iPhone
  11. Delete from two tables in one query
  12. How to load a UIView using a nib file created with Interface Builder
  13. How to install iPhone application in iPhone Simulator
  14. Xcode 5 and iOS 7: Architecture and Valid architectures
  15. How to support both iPad and iPhone retina graphics in universal apps
  16. Set NOW() as Default Value for datetime datatype?
  17. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  18. Strange problem comparing floats in objective-C
  19. How to send Asynchronous URL Request?
  20. Custom iPhone Keyboard
  21. SQL DELETE with JOIN another table for WHERE condition
  22. How to use beginBackgroundTaskWithExpirationHandler for already running task in iOS
  23. Downloading a Large File – iPhone SDK
  24. How to localize bundle display name in iPhone app?
  25. Send image to server as binary data
  26. Fetch Contacts in iOS 7
  27. If I use the PayPal gateway in my iPhone app, will Apple approve it? [closed]
  28. How to set a picture programmatically in a NavBar?
  29. What does it mean by select 1 from table?
  30. How to Play a sound using AVAudioPlayer when in Silent Mode in iPhone

Leave a Comment