[Qgis-user] Detecting Geometry Type For Oracle Object

[Simon Greener]

Jurgen,

Thanks again.

How does one request this rownum<1000 number to be changed or implemented as
a option?
After all all the sdo_geometry types I deal with with customers are
homogeneous based on polygon, line or point with multi... (Oracle users
equate multipolygon with polygons and store them in the same singly
inherited sdo_geometry column regardless as to what the OGC Geometry Type
object diagram says about inheritance.)

Additionally, why is it that even when the value is set in a layer's
<datasource>'s type= attribute eg:

<datasource>dbname='GISDB12' host=localhost port=1522 user='...'
password='...' key='FID' estimatedmetadata=true srid=2872 *type=Polygon*
table="QGIS"."FOO" (GEOM) sql=</datasource>

QGIS still re-queries the database every time for the geometry type the
project is loaded? 

SELECT DISTINCT gtype FROM (SELECT t."GEOMETRY".sdo_gtype AS gtype FROM
"xxxx"."xxxx" t WHERE t."GEOMETRY" IS NOT NULL AND rownum<1000) WHERE
rownum<=2

This re-query slows down project load times especially when one is using
QGIS Server. It would be great if one could stop this re-query once the type
is set when the original layer is set. After all nearly all layer data for
most data sources are of fixed geometry type: Poly, line or point (+ multi).

regards
SImon



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Detecting-Geometry-Type-For-Oracle-Object-tp5305257p5305639.html
Sent from the QGIS - User mailing list archive at Nabble.com.