[fdo][FDO347][New] ArcSDE: Improve schema performance

[Pierre Dalcourt]

You can view the artifact detail at the following URL:

    https://fdo.osgeo.org/servlets/Scarab/id/FDO347

Type
 Enhancement

Artifact ID
 FDO347 (ArcSDE: Improve schema performance)

Reported by
 Pierre Dalcourt
 pierredalcourt (pierre.dalcourt at autodesk.com)

New artifact details:
---------------------------------------------------------

- Summary set to new value
  ArcSDE: Improve schema performance
- Artifact Status set to new value
  New
- Description set to new value
  Improved DescribeSchema performance in ArcSDE.

  1) Cache SE_REGINFO array; re-use it instead of refetching it.

  2) Cache SE_METADATAINFO array; re-use it instead of refetching it.
  Also, fetch it all at once instead of one request per table; this
  is a higher upfront cost but cheaper in the long run since its
  only one fetch to the database instead of many.

  3) Only read fdo-specific schema metadata in debug mode.  This is consistent 
  with the fact that ApplySchema is only supported in debug mode, and ApplySchema 
  is the only command that will generate fdo-specific schema metadata in the 
  database.

  4) If the client hasn't done an explicit DescribeSchema, and we require schema 
  information internally for 1 class only, load only the schema information for 
  that class.  Cache it in case its requested multiple times.  Augment the cache
  intelligently if more classes are requested on a class-by-class basis.

Performance changes were measured.  The configuration was of using a T040p 
laptop client (release mode) in Ottawa against an ArcSDE 9.1 oracle database 
(with 122 arcsde tables) in Florida.
The measure improvements are as follows (averaged results of 2 runs):

  A) DescribeSchema (on ~125 tables): 31.1% improvement (82.6 secs --> 56.9 secs)

  B) Select and read 1088 features twice, calling all Get methods: 87.8% 
  improvement.= (90.3 secs --> 11.05 secs)

  C) Non-measured improvements in locking and long transaction commands, due to 
  Optimization #1 above.

Also fixed some typos.

TESTING PERFORMED:
Ran a variety of unit tests with no new errors.


- Artifact created

---------------------------------------------------------
This message was automatically generated by Project Tracker.