[QGIS-trac] Re: [Quantum GIS] #3453: Postgis layer load starts out with unnecessarily expensive query

[Quantum GIS]

#3453: Postgis layer load starts out with unnecessarily expensive query
------------------------------------------------+---------------------------
   Reporter:  arencambre                        |              Owner:  nobody       
       Type:  bug                               |             Status:  new          
   Priority:  major: does not work as expected  |          Milestone:  Version 1.7.0
  Component:  Data Provider                     |            Version:  1.6.0        
   Keywords:                                    |   Platform_version:  7            
   Platform:  Debian                            |           Must_fix:  No           
Status_info:  0                                 |  
------------------------------------------------+---------------------------

Comment(by jef):

 Isn't that your view?  views usually don't have an entry in
 {{{geometry_columns}}}.  Additionally the query you mention should only
 run, when the geometry type of the layer is not known beforehand (ie.
 {{{GEOMETRY}}} instead of a specific type).  And with large datasets you
 probably want to enable "use estimated data", which should limit the query
 to deduce the geometry type to the first 100 rows.

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/3453#comment:1>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats