[TYPO3-dev] Remove records from extbase query result
Philipp
philippwrann at gmx.at
Fri Jan 17 08:35:29 CET 2014
And if you (in case a maximum distance is requested) add the bounding-box constraints before you do the real radial search? Wouldnt mysql then -in case of the first constraint fails- ignore the haversine?
a final query like:
select *, (...) as distance from .. where
(latitude < a and latitude > b) and (longitude < c and longitude > d) and (distance < e)
order by distance
how would mysql perform here?
More information about the TYPO3-dev
mailing list