[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