On 2/15/2012 7:04 AM, Rahkonen Jukka wrote:
Even Rouault wrote:
Le mardi 14 février 2012 09:24:15, Rahkonen Jukka a écrit :
Rahkonen Jukka wrote:
Even Rouault wrote:
I've commited improvements in GDAL trunk for both points (
http://trac.osgeo.org/gdal/changeset/23944 and
http://trac.osgeo.or
Even Rouault wrote:
>
> Le mardi 14 février 2012 09:24:15, Rahkonen Jukka a écrit :
> > Rahkonen Jukka wrote:
> > > Even Rouault wrote:
> > > >> I've commited improvements in GDAL trunk for both points (
> > > >> http://trac.osgeo.org/gdal/changeset/23944 and
> > > >> http://trac.osgeo.org/gdal/c
Le mardi 14 février 2012 09:24:15, Rahkonen Jukka a écrit :
> Rahkonen Jukka wrote:
> > Even Rouault wrote:
> > >> I've commited improvements in GDAL trunk for both points (
> > >> http://trac.osgeo.org/gdal/changeset/23944 and
> > >> http://trac.osgeo.org/gdal/changeset/23945 ) that make the
> >
o.org'
Subject: Re: [mapserver-users] Does Mapserver utilise Spatialite spatial index
correctly?
Rahkonen Jukka wrote:
>
> Even Rouault wrote:
>
> >
> >> I've commited improvements in GDAL trunk for both points (
> >> http://trac.osgeo.org/gdal/cha
Rahkonen Jukka wrote:
>
> Even Rouault wrote:
>
> >
> >> I've commited improvements in GDAL trunk for both points (
> >> http://trac.osgeo.org/gdal/changeset/23944 and
> >> http://trac.osgeo.org/gdal/changeset/23945 ) that make the
> above request go
> >> from 1.7 sec to 0.54 sec . I don't th
Rouault; mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Does Mapserver utilise Spatialite spatial index
correctly?
Even Rouault wrote:
>
>> I've commited improvements in GDAL trunk for both points (
Awesome! About 25 times faster in the evening than it was in t
Quite an interesting discussion! Thanks guys.
-jeff
On 12-02-11 5:44 PM, Even Rouault wrote:
Jukka,
I've continued playing with your OSM data.
I've got extra performance by adding attribute indexes, so that every field you
use in a WHERE clause is indexed. For example for the roadsclose, r
Jukka,
I've continued playing with your OSM data.
I've got extra performance by adding attribute indexes, so that every field you
use in a WHERE clause is indexed. For example for the roadsclose, railways and
landuse layers, you could create the following indexes:
CREATE INDEX idx_osm_line_rai
Even Rouault wrote:
>
>> I've commited improvements in GDAL trunk for both points (
>> http://trac.osgeo.org/gdal/changeset/23944 and
>> http://trac.osgeo.org/gdal/changeset/23945 ) that make the above request go
>> from 1.7 sec to 0.54 sec . I don't think there's any more significant speed
>> ga
>
> I've commited improvements in GDAL trunk for both points (
> http://trac.osgeo.org/gdal/changeset/23944 and
> http://trac.osgeo.org/gdal/changeset/23945 ) that make the above request go
> from 1.7 sec to 0.54 sec . I don't think there's any more significant speed
> gain to expect now (at least
Le samedi 11 février 2012 12:53:08, Even Rouault a écrit :
> Le samedi 11 février 2012 11:42:00, Rahkonen Jukka a écrit :
> > Hi,
> >
> > Perhaps it is not the spatial index at all, or it is not the most
> > important part? It looks like OGR is using Spatialite through a
> > connection pool and cr
Le samedi 11 février 2012 11:42:00, Rahkonen Jukka a écrit :
> Hi,
>
> Perhaps it is not the spatial index at all, or it is not the most important
> part? It looks like OGR is using Spatialite through a connection pool and
> creating a new connection and pool is pretty heavy. A first aid with a
>
; Lime, Steve D (DNR)
Kopio: 'mapserver-users@lists.osgeo.org'
Aihe: Re: [mapserver-users] Does Mapserver utilise Spatialite spatial index
correctly?
Hi,
Sorry about long message but I like pretty much about the idea to be able to
send Mapserver, mapfiles and data in one single package so
Lähetetty: 10. helmikuuta 2012 19:05
Vastaanottaja: Lime, Steve D (DNR)
Kopio: Rahkonen Jukka; 'mapserver-users@lists.osgeo.org'
Aihe: RE: [mapserver-users] Does Mapserver utilise Spatialite spatial index
correctly?
Selon "Lime, Steve D (DNR)" :
> The changeset in OGR is
n...@lists.osgeo.org
> [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Rahkonen Jukka
> Sent: Friday, February 10, 2012 9:36 AM
> To: 'mapserver-users@lists.osgeo.org'
> Subject: Re: [mapserver-users] Does Mapserver utilise Spatialite spatial
> index correctly?
-boun...@lists.osgeo.org] On Behalf Of Rahkonen Jukka
Sent: Friday, February 10, 2012 9:36 AM
To: 'mapserver-users@lists.osgeo.org'
Subject: Re: [mapserver-users] Does Mapserver utilise Spatialite spatial index
correctly?
Hi,
OK, lets put it this way:
Is it sure that Mapserver is firing th
Hi,
OK, lets put it this way:
Is it sure that Mapserver is firing the BBOX query so that GDAL/OGR understands
to follow the path that is implemented in
http://trac.osgeo.org/gdal/changeset/23008
instead of making an inefficient MBRIntersects() query or some other slow
query?
I do not believe
There is no native support for Spatialite in MapServer, it's all through
GDAL/OGR.
Steve
From: mapserver-users-boun...@lists.osgeo.org
[mapserver-users-boun...@lists.osgeo.org] on behalf of Rahkonen Jukka
[jukka.rahko...@mmmtike.fi]
Sent: Friday, February 10, 2
18 matches
Mail list logo
