To all,
I've got a query performance problem I'm trying to track down. I was
hopeful that 5.6 with RFC 52 implemented might help me, but it seems to
have no impact.
Are the changes for RFC 52 implemented for OGR ODBC connections?
Thanks!
Brent Fraser
___
: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] mapserver 5.6.0, RFC 52 and driver support
To all,
I've got a query performance problem I'm trying to track down. I was
hopeful that 5.6 with RFC 52 implemented might help me, but it seems to
have no impact.
Are the changes
> -Original Message-
> From: mapserver-users-boun...@lists.osgeo.org
> [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Brent Fraser
> Sent: Tuesday, December 22, 2009 2:48 PM
> To: mapserver-users@lists.osgeo.org
> Subject: [mapserver-users] mapserver 5.
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Brent Fraser
Sent: Tuesday, December 22, 2009 2:55 PM
To: Lime, Steve D (DNR)
Cc: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] mapserver 5.6.0, RFC 52 and driver support
Do you think there would be any point in making the
Brent Fraser wrote:
Do you think there would be any point in making the changes for OGR (for
my ODBC -> Sql Server connection)? If so, I'll start having a look at the
code...
Brent
The improvements are limited to native drivers only, principally Oracle
Spatial and PostGIS.
Brent,
I believe
Brent
>> Fraser
>> Sent: Tuesday, December 22, 2009 2:48 PM
>> To: mapserver-users@lists.osgeo.org
>> Subject: [mapserver-users] mapserver 5.6.0, RFC 52 and driver support
>>
>> To all,
>>
>> I've got a query performance problem I'm tr
: RE: [mapserver-users] mapserver 5.6.0, RFC 52 and driver support
The strange thing is the image render is quick (a few seconds), but the
nquery+mapshape (rectangle) with the processing of the template is several
minutes. And while it opens/reads/closes the template file for each
record(!), I
2009 3:10 PM
> To: Lime, Steve D (DNR)
> Cc: mapserver-users@lists.osgeo.org
> Subject: RE: [mapserver-users] mapserver 5.6.0, RFC 52 and driver support
>
> The strange thing is the image render is quick (a few seconds), but the
> nquery+mapshape (rectangle) with the processing o
t: RE: [mapserver-users] mapserver 5.6.0, RFC 52 and driver support
> What kind of templating are you using? The old-style stuff or the
> new-style? How many results you talking?
Old style. Low 100's of records returned...
>
> -Original Message-
> From: Brent Fraser [mailt
rom: Brent Fraser [mailto:bfra...@geoanalytic.com]
> Sent: Tuesday, December 22, 2009 3:34 PM
> To: Lime, Steve D (DNR)
> Cc: mapserver-users@lists.osgeo.org
> Subject: RE: [mapserver-users] mapserver 5.6.0, RFC 52 and driver support
>
>> What kind of templating are you using? The old-style stuf
Yup. What sort of an example would help?
-Original Message-
From: Brent Fraser [mailto:bfra...@geoanalytic.com]
Sent: Tuesday, December 22, 2009 4:18 PM
To: Lime, Steve D (DNR)
Cc: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] mapserver 5.6.0, RFC 52 and driver support
riginal Message-
> From: Brent Fraser [mailto:bfra...@geoanalytic.com]
> Sent: Tuesday, December 22, 2009 4:18 PM
> To: Lime, Steve D (DNR)
> Cc: mapserver-users@lists.osgeo.org
> Subject: RE: [mapserver-users] mapserver 5.6.0, RFC 52 and driver support
>
> I'd like to gi
> Brent Fraser wrote:
>> Do you think there would be any point in making the changes for OGR (for
>> my ODBC -> Sql Server connection)? If so, I'll start having a look at
>> the
>> code...
>>
>> Brent
>>
>>> The improvements are limited to native drivers only, principally Oracle
>>> Spatial and Po
d help?
>>
>> -----Original Message-----
>> From: Brent Fraser [mailto:bfra...@geoanalytic.com]
>> Sent: Tuesday, December 22, 2009 4:18 PM
>> To: Lime, Steve D (DNR)
>> Cc: mapserver-users@lists.osgeo.org
>> Subject: RE: [mapserver-users] mapserver 5.6.0,
e?
Thanks
Brent
> Yup. What sort of an example would help?
>
> -Original Message-
> From: Brent Fraser [mailto:bfra...@geoanalytic.com]
> Sent: Tuesday, December 22, 2009 4:18 PM
> To: Lime, Steve D (DNR)
> Cc: mapserver-users@lists.osgeo.org
> Subject: RE: [map
Brent Fraser wrote:
Brent Fraser wrote:
Do you think there would be any point in making the changes for OGR (for
my ODBC -> Sql Server connection)? If so, I'll start having a look at
the
code...
Brent
The improvements are limited to native drivers only, principally Oracle
Spatial and PostGIS
Frank,
With the new changes, the query takes about 5 minutes (2.5 minutes for
the first pass and 2.5 minutes for the second) to return the 868
records.
Using the old mapogr.c it would take 2.5 minutes (the first pass) + 1
minute/record (the second pass) = 15 hours (est). This is connecting t
ery&qformat=UnassignedWells_select_template&map=select2_Test.map&qlayer=UnAssignedWells&"
>>
>> Am I close?
>>
>> Thanks
>> Brent
>>
>>
>>> Yup. What sort of an example would help?
>>>
>>> -Original Messa
t;> QUERY_STRING="mode=nquery&qformat=UnassignedWells_select_template&map=select2_Test.map&qlayer=UnAssignedWells&"
>>
>> Am I close?
>>
>> Thanks
>> Brent
>>
>>
>>> Yup. What sort of an example would help?
>>>
&
19 matches
Mail list logo