[fdo-trac] #237: SQLServer Spatial: optimize SELECT SpatialExtents() for performance

FDO trac_fdo at osgeo.org
Wed Jan 23 12:26:23 EST 2008


#237: SQLServer Spatial: optimize SELECT SpatialExtents() for performance
---------------------------------+------------------------------------------
   Reporter:  danstoica          |       Owner:  danstoica
       Type:  enhancement        |      Status:  new      
   Priority:  major              |   Milestone:  3.3.0    
  Component:  SQLServer Spatial  |     Version:  3.3.0    
   Severity:  3                  |    Keywords:           
External_id:                     |  
---------------------------------+------------------------------------------
 NOTE: SELECT COUNT(), SpatialExtents() is optimized.

 Found that "select <column>.STEnvelope().STAsBinary() as MBR from <table>"
 is 3 times slower than straithforward "select <column>.STAsBinary() as MBR
 from <table>"

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/237>
FDO <http://fdo.osgeo.org/>
Feature Data Objects


More information about the fdo-trac mailing list