> 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
