Even Rouault wrote:
30. August 2011 23:28
I've just added support for spatialite views in GDAL trunk
(r23011). Spatial
index of the base table is used to speed up spatial queries
on the view.
On your example, to create the spatial view :
ogrinfo berlin.sqlite -sql create view
-Alkuperäinen viesti-
Lähettäjä: Even Rouault [mailto:even.roua...@mines-paris.org]
Lähetetty: 30. elokuuta 2011 23:28
Vastaanottaja: mapserver-users@lists.osgeo.org
Kopio: Rahkonen Jukka
Aihe: Re: [mapserver-users] Re: Mapserver unnecessary slow
with Spatialite
Le mardi 30
conclusion: using the current implementation of
ogr2ogr in order to create any SpatiaLite DB
is a really hazardous option.
I've already prepared several patches for OGR:
and I hope to be able to release all them ASAP.
yeah, I'm aware (actually Sandro let me know some time ago) that there
Hi,
Even Rouault made a fix yesterday into the ogr sqlite driver. It gave 11 times
more speed when doing small BBOX selections from a smallish table with 9
linestrings. These queries are very typical for Mapserver and thus when the
gdal version behind Mapserver is updated people should see
Le mardi 30 août 2011 11:07:57, Rahkonen Jukka a écrit :
Hi,
Even Rouault made a fix yesterday into the ogr sqlite driver. It gave 11
times more speed when doing small BBOX selections from a smallish table
with 9 linestrings. These queries are very typical for Mapserver and
thus when
Hi,
I did have the views on my mind but I thought that if they were used ogr would
perhaps loose the spatial index of the Spatialite table. Good if views will
work. It feels like a solid solution even it means playing both with the
mapfile and on the Spatialite side when creating new layers.