[Tiling] Tilestore Benchmarks

[Oliver Tonnhofer]

Hi Stephan,

On 06.05.2011, at 14:11, Stephan Holl wrote:
> Thanks for the facts.
> 
> Is there any magic inside your SQLite-DB? What specs apply inside the
> schema?

No magic applied. Plain Python 2.7.1 (./configure && make install) with SQLite 3.6.22.

Here is the schema:
CREATE TABLE tiles (id INTEGER PRIMARY KEY, x INTEGER, y INTEGER, blob BLOB)
CREATE INDEX idx_tiles_xy ON tiles (x, y)

Here is a select for a single tile:
SELECT blob FROM tiles WHERE x = ? AND y = ?;

and for meta tile requests:
SELECT blob FROM tiles WHERE (x = ? AND y = ?) OR (x = ? AND y = ?)....

Regards,
Oliver

-- 
Oliver Tonnhofer    | Omniscale GmbH & Co KG    | http://omniscale.de
http://mapproxy.org | https://bitbucket.org/olt | @oltonn