[Tiling] Tilestore Benchmarks

[Stephan Holl]

Hello Oliver,

Oliver Tonnhofer <olt at omniscale.de>, [20110502 - 15:35:54]

> Hi there,
> 
> I promised to post my benchmarks of an SQLite based tile store. I had
> to rerun my tests with different options and different cache sizes,
> but here are finally the results:
> 
> http://dev.mapproxy.org/misc/tilestorebench/
> 
> As you'll notice, SQLite is faster in any benchmark and some of the
> numbers are quite impressive.
> 
> With a hot filecache, the SQLite store peeked at 26k tiles/s while
> the file system peeked only at 2.5k (the graphs are smoothed with a
> running average of 10). Even for tile sets that do not fit in memory
> SQLite is much faster (~300 vs. ~150t/s with meta requests, ~85 vs
> ~40t/s for complete random requests). 

Thanks for the facts.

Is there any magic inside your SQLite-DB? What specs apply inside the
schema?

TIA
	
	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/7a8d2321/signature.bin