[MS4W-Users] Fwd: exciting news from SQLite

[Jeff McKenna]

Sharing this news with the MS4W community (as Spatialite and all of its 
commandline tools are packaged with MS4W 3.2.0)



-------- Forwarded Message --------

Hi list,

the developer of SQLite have recently introduced an astonishing code
optimization ensuring a noticeable performance boost on all operations
involving the R*Tree module (Spatial Index).

this change is still experimental, but will probably be supported by
the next 3.17 release.

just few comparative timings:

dataset housenumbers: more than 1 million points
================================================

test #1 - CreateSpatialIndex:
old: 26.775 sec
new: 17.416 sec

test #2 - Random Spatial Index Queries
old: 30.371 sec
new: 23.009 sec


dataset buiildings: more than 1 million polygons
================================================

test #1 - CreateSpatialIndex:
old: 20.257 sec
new: 12.495 sec

test #2 - Random Spatial Index Queries
old: 55.993 sec
new: 41.005 sec


dataset geonames: more than 11 million points
=============================================

test #1 - CreateSpatialIndex:
old: 223.108 sec
new: 142.667 sec

test #2 - Random Spatial Index Queries
old: 4.973 sec
new: 4.157 sec


bye Sandro