On Tue, Jan 17, 2006 at 10:00:22AM -0800, sunithab@travelpost.com wrote:
> I have a latiude and longitude for a city and latitude, longitude foreach
> hotel in hotels table.
>
> I have to reitreive 20 hotels nearby to that city in 25 miles. The below
> is the query I am using to check the distance. But the query is slow
> because of distance calulation on fly and order by distance.
You appear to be using PostGIS but the query you posted doesn't use
any of PostGIS's indexable operators. Have you read the "Using
PostGIS" documentation, in particular the parts that discuss creating
and using indexes on geometry columns?
http://postgis.refractions.net/docs/ch04.html
Your data looks like it has separate lat/lon columns when it should
have a geometry column with a GiST index.
If you're using PostGIS then you might want to subscribe to the
postgis-users mailing list:
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Michael Fuhr