Yup. What sort of an example would help? -----Original Message----- From: Brent Fraser [mailto:[email protected]] Sent: Tuesday, December 22, 2009 4:18 PM To: Lime, Steve D (DNR) Cc: [email protected] 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:[email protected]] > Sent: Tuesday, December 22, 2009 3:34 PM > To: Lime, Steve D (DNR) > Cc: [email protected] > 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:[email protected]] >> Sent: Tuesday, December 22, 2009 3:10 PM >> To: Lime, Steve D (DNR) >> Cc: [email protected] >> 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: [email protected] >>> [mailto:[email protected]] On Behalf Of Brent >>> Fraser >>> Sent: Tuesday, December 22, 2009 2:55 PM >>> To: Lime, Steve D (DNR) >>> Cc: [email protected] >>> 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: [email protected] >>>> [mailto:[email protected]] On Behalf Of Brent >>>> Fraser >>>> Sent: Tuesday, December 22, 2009 2:48 PM >>>> To: [email protected] >>>> 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 >>>> [email protected] >>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users >>>> >>> >>> >>> _______________________________________________ >>> mapserver-users mailing list >>> [email protected] >>> http://lists.osgeo.org/mailman/listinfo/mapserver-users >>> >> >> >> > > > _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
