[fdo-trac] #744: RDBMS: Incremental DescribeSchema tuning.

FDO trac_fdo at osgeo.org
Mon Jan 31 15:52:21 EST 2011


#744: RDBMS: Incremental DescribeSchema tuning.
--------------------------------+-------------------------------------------
   Reporter:  brentrobinson     |       Owner:  brentrobinson                         
       Type:  enhancement       |      Status:  new                                   
   Priority:  major             |   Milestone:  3.6.0                                 
  Component:  GenericRdbms API  |     Version:  3.6.0                                 
   Severity:  3                 |    Keywords:  incremental DescribeSchema performance
External_id:                    |  
--------------------------------+-------------------------------------------
 The following sequence of steps:

     - execute FdoIGetClassNames
     - execute FdoIDescribeSchema for a list of classes

 can be slow because the FdoIDescribeSchema step ends up fetching the
 classes one table or view at a time from the RDBMS server.

 For example, for the SQLServerSpatial provider, describing 20 feature
 classes from a 1500 class local datastore takes 8 seconds.

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


More information about the fdo-trac mailing list