Random thoughts of an Irish Software Architect in the GIS Industry.
Spatial Sorting of Data based on location
Very handy tip today on how to drastically improve seek times in results for spatial queries, by physically re-ordering the rows of data to be contiguous on disk.
VERY HANDY.
SpatialDB Advisor: Spatial Sorting of Data via Morton Key