Hi guys, In a project I'm working on, I have a list (about 1700) locations in my database.
I need to get a small subset of these, based on their closeness to my current location. In previous projects, I've used MySQL math functions (cos, acos, etc) to achieve this, but SQLlite doesn't have these built in. Doing it by looping through all locations and comparing them against location.distanceTo() is really quite slow for this number of locations. It takes a good 20 seconds or so on my Nexus One. Has anyone found an efficient way to accomplish this? Thanks -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
