[fdo-trac] #250: RDBMS Provider Performance: Lazy load properties retrieved by FdoIDataStoreReader

[FDO]

#250: RDBMS Provider Performance: Lazy load properties retrieved by
FdoIDataStoreReader
------------------------------+---------------------------------------------
   Reporter:  brentrobinson   |       Owner:  brentrobinson                                                           
       Type:  enhancement     |      Status:  new                                                                     
   Priority:  major           |   Milestone:  3.3.0                                                                   
  Component:  MySQL Provider  |     Version:  3.3.0                                                                   
   Severity:  2               |    Keywords:  List Datastores FdoIListDatastores FdoIDatastoreReader MySQL performance
External_id:                  |  
------------------------------+---------------------------------------------
 Listing datastores can be slow when the RDBMS instance has many
 datastores. For example, a MySQL instance over the LAN from the client can
 take 4 minutes to list 313 datastores.

 The most expensive part of listing the datastores is retrieving the
 description, long transaction mode and locking mode for FDO-enabled
 datastores. However, not all client applications need this information.

 This enhancement will lazy-load these properties by only retrieving them
 when the application askes for them via an
 FdoIDatastoreReader::GetDescription() or
 FdoIDatastoreReader::GetProperties() call.

 Another enhancement to the MySQL will be to load the FDO-enabled statuses
 in a single select, rather than a subselect of the query that retrieves
 datastore names.

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