[Benchmarking] data block caching technique

[Andrea Aime]

Right right, that's actually some really nice improvement that we can
try next year: clustering the shapefiles
along the spatial index. It's a common technique in databases that
nobody tried out in this benchmark
(and which would have been a valid best effort approach).

That said I think at least the contour shapefiles do present some
actual spatial clustering given the
way they were created (afaik Ivan merged them from smaller files that
he created, and each of
those files is clearly visible if you preview the shapefile at the
whole Spain level).

Cheers
Andrea

On Mon, Sep 6, 2010 at 10:16 PM, Liujian (LJ) Qian <LJ.Qian at oracle.com> wrote:
>  Or that.  Note however most blocks (as cached by the FS) will probably
> contain data that does not belong to the working set?   In other words, I
> assume the shapefiles do not always store geographically adjacent records in
> the same or neighboring blocks; but I don't really know about the
> clustered-ness within the .shp and .dbf files.