Android SQLite query to get closest location to a given longitude and latitude from a big dataset?
===

I have about 15,000 records of longitude and latitude locations in my table and I want to select the top 10 that are closest to the user's longitude and latitude.

How should I approach this?

I don't think I can do a bounding box because it would take too long for the query to finish. So I am lost at what else I can do.

Thanks.