[fdo][FDO198][Modified] DescribeSchema slow after Oracle Cache flush performed

[Brent Robinson]

You can view the artifact detail at the following URL:

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

Type:
Defect

Artifact ID:
FDO198 (DescribeSchema slow after Oracle Cache flush performed)

Modified by:
Brent Robinson
brentrobinson (brent.robinson at autodesk.com)

The following modifications were made to this artifact:
---------------------------------------------------------------------

-- Defect Resolution set to new value:
Submitted
-- Resolution Description set to new value:
Moved SpatialContextGeom cache to the Physical Schema Manager so that column dimensionality can be obtained from this cache. 

Added bulk loading for the f_attributedependencies rows, to reduce the number of query executions against this table. 

Skipped bulk load of unique and check constraints, unless an ApplySchema or DescribeSchema is being performed. This causes these queries to be skipped on datastore open.

Skipped bulk loading of corresponding tables for the F_MetaClass schema. The only table needed (f_classdefinition) is already loaded when this bulk load is attempted.

-- Artifact Status changed:
Old value:
Assigned
New value:
Resolved



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