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

[Lime, Steve D (DNR)]

Quite close. Output format should be (5.6 doesn't require the quotes around TEMPLATE in the driver line):

OUTPUTFORMAT
  NAME 'UnassignedWells_select_template'
  DRIVER 'TEMPLATE'
  MIMETYPE 'text/html'
  FORMATOPTION 'FILE=database\UnassignedWells_select_template_test.html'
END

Your URL looks fine.

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 4:30 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

I've got:
  OUTPUTFORMAT
    NAME 'UnassignedWells_select_template'
    DRIVER 'TEMPLATE'
    MIMETYPE 'text/html'
    TEMPLATE 'database\UnassignedWells_select_template_test.html'
#?    FORMATOPTION 'FILE=database\UnassignedWells_select_template_test.html'
  END

in my map file and a command line of:

mapserv
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?
>
> -----Original Message-----
> From: Brent Fraser [mailto:bfraser at geoanalytic.com]
> Sent: Tuesday, December 22, 2009 4:18 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
>
> I'd like to give the new-style approach a try, but the doc seems a little
> thin.  You've talking about RFC 36 right?
>
>> The new-style approach opens the template only once. That's not your
>> bottleneck though I bet...
>>
>> -----Original Message-----
>> From: Brent Fraser [mailto:bfraser at geoanalytic.com]
>> Sent: Tuesday, December 22, 2009 3:34 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
>>
>>> 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
>>>>
>>>
>>>
>>>
>>
>>
>>
>
>
>


_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users