[mapserver-dev] OGR/MySQL Layer executes SQL query twice

[deuce2367]

Steve,

That's a good suggestion.  I'm running a very simple test where I use
shp2img with a straightforward map file but if I used ogr2ogr that would
take Mapserver out of the equation altogether.  I'll try and set up such a
test and see what happens.

Cheers,

-Andy


On Wed, Apr 10, 2013 at 2:06 PM, Lime, Steve D (MNIT) [via OSGeo.org] <
ml-node+s1560n5045879h77 at n6.nabble.com> wrote:

> Is there a way to test your theory independent of MapServer using OGR
> only? I don't know the MapServer OGR driver well but I can't imagine this
> is normal.
>
> Steve
>
> -----Original Message-----
> From: [hidden email]<http://user/SendEmail.jtp?type=node&node=5045879&i=0>[mailto:[hidden
> email] <http://user/SendEmail.jtp?type=node&node=5045879&i=1>] On Behalf
> Of deuce2367
> Sent: Tuesday, April 09, 2013 9:20 AM
> To: [hidden email] <http://user/SendEmail.jtp?type=node&node=5045879&i=2>
> Subject: [mapserver-dev] OGR/MySQL Layer executes SQL query twice
>
> I'm using Mapserver 6.0.2 and GDAL 1.7.2 and have created a mapfile with
> an OGR/MySQL layer.  The SQL query that retrieves the spatial data is
> fairly slow, takes about 8-10 seconds.  I've noticed that whenever I render
> the layer (via the mapserv binary or via the shp2img utility) that the
> query executes two times.  I thought this was maybe some sort of
> introspection/reflection issue where perhaps OGR is trying to characterize
> the data somehow so I made sure to create and populate the geometry_columns
> table but that doesn't seem to help, it's still running the SQL query
> twice.
> Incidentally it's also performing 2 describes and 2 'select from
> geometry_columns...' as well.
>
> Is this normal and expected?
>
> I apologize if this is a repeat, I didn't find any references to this
> observation in my searches.  Appreciate any help,
>
> -Andy Smith
>
>
>
>
> --
> View this message in context:
> http://osgeo-org.1560.x6.nabble.com/OGR-MySQL-Layer-executes-SQL-query-twice-tp5045536.html
> Sent from the Mapserver - Dev mailing list archive at Nabble.com.
> _______________________________________________
> mapserver-dev mailing list
> [hidden email] <http://user/SendEmail.jtp?type=node&node=5045879&i=3>
> http://lists.osgeo.org/mailman/listinfo/mapserver-dev
>
>
> _______________________________________________
> mapserver-dev mailing list
> [hidden email] <http://user/SendEmail.jtp?type=node&node=5045879&i=4>
> http://lists.osgeo.org/mailman/listinfo/mapserver-dev
>
>
> ------------------------------
>  If you reply to this email, your message will be added to the discussion
> below:
>
> http://osgeo-org.1560.x6.nabble.com/OGR-MySQL-Layer-executes-SQL-query-twice-tp5045536p5045879.html
>  To unsubscribe from OGR/MySQL Layer executes SQL query twice, click here<http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5045536&code=YXBzbWl0aDIzNjdAZ21haWwuY29tfDUwNDU1MzZ8LTE4ODM1NjA5MDc=>
> .
> NAML<http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>




--
View this message in context: http://osgeo-org.1560.x6.nabble.com/OGR-MySQL-Layer-executes-SQL-query-twice-tp5045536p5045913.html
Sent from the Mapserver - Dev mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-dev/attachments/20130410/c2b21b37/attachment.html>