[mapserver-users] mapserver 5.6.0, RFC 52 and driver support

Brent Fraser bfraser at geoanalytic.com
Tue Dec 22 16:33:46 EST 2009


> 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 [mailto:bfraser at geoanalytic.com]
> Sent: Tuesday, December 22, 2009 3:10 PM
> To: Lime, Steve D (DNR)
> Cc: mapserver-users at 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 of the template is several
> minutes.  And while it opens/reads/closes the template file for each
> record(!), I suspect the majority of the time is spent requesting the
> record and dealing with the result.
>
> Ok, on goes the hacker suit...
>
> Thanks!
> Brent
>
>> Probably a question better answered by OGR maintainers... In theory
>> working off a single
>> result set, even if you have to traverse it more than once, would be far
>> more efficient
>> than id-based lookups done now.
>>
>> Steve
>>
>> -----Original Message-----
>> From: mapserver-users-bounces at lists.osgeo.org
>> [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Brent
>> Fraser
>> Sent: Tuesday, December 22, 2009 2:55 PM
>> To: Lime, Steve D (DNR)
>> Cc: mapserver-users at 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 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.
>>>
>>> Steve
>>>
>>> -----Original Message-----
>>> From: mapserver-users-bounces at lists.osgeo.org
>>> [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Brent
>>> Fraser
>>> Sent: Tuesday, December 22, 2009 2:48 PM
>>> To: mapserver-users at 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 for RFC 52 implemented for OGR ODBC connections?
>>>
>>> Thanks!
>>> Brent Fraser
>>>
>>> _______________________________________________
>>> mapserver-users mailing list
>>> mapserver-users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>>>
>>
>>
>> _______________________________________________
>> mapserver-users mailing list
>> mapserver-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>>
>
>
>




More information about the mapserver-users mailing list