[Tiling] Tilestore Benchmarks

[Stephan Holl]

Hello Oliver,

Oliver Tonnhofer <olt at omniscale.de>, [20110506 - 14:18:50]

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

thanks for that, I already thought about such simple solution.

Anyway, good to know that there is some optimizing-potential left for
further development.

Best

	Stephan


-- 
Stephan Holl <stephan.holl at intevation.de> | Tel.: +49 (0)541-33 508 3663
Intevation GmbH, Neuer Graben 17, 49074 OS  |  AG Osnabrück - HR B 18998
Geschäftsführer:  Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/tiling/attachments/20110506/9ec5cc16/signature.bin