[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