[Tiling] Tilestore Benchmarks

[christopher.schmidt at nokia.com]

On May 6, 2011, at 8:18 AM, ext Oliver Tonnhofer wrote:

> 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 = ?)....

No Z?

-- Chris