Re:SQLite small blob storage: 35% Faster Than the Filesystem
by incanus77 on Wednesday June 14, 2017 @01:22PM
(#14554273)
Also, to clarify a bit on why spatial capabilities weren't part of the MBTiles spec: when rendering maps, you assemble tiles for a given zoom scale in the vertical and horizontal directions, like a checkerboard. The unique tuple defining a particular square on the map is z/x/y — zoom level, horizontal, vertical. So stuffing these into SQLite and uniquely keying across z/x/y there makes for fast retrieval at render time.
[ Parent
| on HN ]
There are no comments on this comment yet.