After moving database queries are very slow

Jerry Stuckle wrote:

> Ralph,
>
> Listen to the others here. Don't calculate the earth_distance_miles for
> every item in your database. It is not only causing a table scan, it is
> calculating this for every row in your table. That's a huge amount of
> unnecessary overhead. Even 2 seconds is too long.
>

Thank you I rewrote the query and now it's fine :)

Thank you again

--

Ralph