yes you can do this...

add a where condition and add

where

X(Geomfromtext(Astext(latlong))) between 51.585738 and 51.585738+4

and

Y(Geomfromtext(Astext(latlong))) between -0.260878 and -0.260878+4

what I think is, filter the data first before calculating the distance for all points...

hope it may improve it :)

add a where condition and add

where

X(Geomfromtext(Astext(latl

and

Y(Geomfromtext(Astext(latl

what I think is, filter the data first before calculating the distance for all points...

hope it may improve it :)