[MS4W-Users] Fwd: exciting news from SQLite

[Jeff McKenna]

related: I saw this mentioned on spatialite-users:


http://www.gaia-gis.it/gaia-sins/spatialite-sql-latest.html

you will see a list of spatialite SQL-Commands
- that you cannot use with sqlite3(.exe), but can use with spatialite(.exe)

Very cool!

-jeff


-- 
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/



On 2017-02-03 4:23 PM, Jeff McKenna via MS4W-Users wrote:
> 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
>
>