[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:
---------------------------------------------------------------------

Added following comment to artifact::

Automated Comment.  Version control commit message.

FDO198: breaks up the Oracle Foreign Key query into 2 selects to improve performance. Adds bulk loading for the f_attributedependencies rows.
Reviewed by Barbara Zoladek.

Modified
File: branches/3.2.x/Utilities/SchemaMgr/Inc/Sm/Ph/DbObject.h https://fdocore.osgeo.org/source/browse/fdocore/branches/3.2.x/Utilities/SchemaMgr/Inc/Sm/Ph/DbObject.h?view=diff&rev=427&p1=branches/3.2.x/Utilities/SchemaMgr/Inc/Sm/Ph/DbObject.h&r1=426&p2=branches/3.2.x/Utilities/SchemaMgr/Inc/Sm/Ph/DbObject.h&r2=427
File: branches/3.2.x/Utilities/SchemaMgr/Inc/Sm/Ph/DependencyReader.h https://fdocore.osgeo.org/source/browse/fdocore/branches/3.2.x/Utilities/SchemaMgr/Inc/Sm/Ph/DependencyReader.h?view=diff&rev=427&p1=branches/3.2.x/Utilities/SchemaMgr/Inc/Sm/Ph/DependencyReader.h&r1=426&p2=branches/3.2.x/Utilities/SchemaMgr/Inc/Sm/Ph/DependencyReader.h&r2=427
File: branches/3.2.x/Utilities/SchemaMgr/Inc/Sm/Ph/Rd/Join.h https://fdocore.osgeo.org/source/browse/fdocore/branches/3.2.x/Utilities/SchemaMgr/Inc/Sm/Ph/Rd/Join.h?view=diff&rev=427&p1=branches/3.2.x/Utilities/SchemaMgr/Inc/Sm/Ph/Rd/Join.h&r1=426&p2=branches/3.2.x/Utilities/SchemaMgr/Inc/Sm/Ph/Rd/Join.h&r2=427
File: branches/3.2.x/Utilities/SchemaMgr/Inc/Sm/Ph/TableComponentReader.h https://fdocore.osgeo.org/source/browse/fdocore/branches/3.2.x/Utilities/SchemaMgr/Inc/Sm/Ph/TableComponentReader.h?view=diff&rev=427&p1=branches/3.2.x/Utilities/SchemaMgr/Inc/Sm/Ph/TableComponentReader.h&r1=426&p2=branches/3.2.x/Utilities/SchemaMgr/Inc/Sm/Ph/TableComponentReader.h&r2=427
File: branches/3.2.x/Utilities/SchemaMgr/Src/Sm/Ph/DbObject.cpp https://fdocore.osgeo.org/source/browse/fdocore/branches/3.2.x/Utilities/SchemaMgr/Src/Sm/Ph/DbObject.cpp?view=diff&rev=427&p1=branches/3.2.x/Utilities/SchemaMgr/Src/Sm/Ph/DbObject.cpp&r1=426&p2=branches/3.2.x/Utilities/SchemaMgr/Src/Sm/Ph/DbObject.cpp&r2=427
File: branches/3.2.x/Utilities/SchemaMgr/Src/Sm/Ph/DependencyReader.cpp https://fdocore.osgeo.org/source/browse/fdocore/branches/3.2.x/Utilities/SchemaMgr/Src/Sm/Ph/DependencyReader.cpp?view=diff&rev=427&p1=branches/3.2.x/Utilities/SchemaMgr/Src/Sm/Ph/DependencyReader.cpp&r1=426&p2=branches/3.2.x/Utilities/SchemaMgr/Src/Sm/Ph/DependencyReader.cpp&r2=427
File: branches/3.2.x/Utilities/SchemaMgr/Src/Sm/Ph/Mt/ClassReader.cpp https://fdocore.osgeo.org/source/browse/fdocore/branches/3.2.x/Utilities/SchemaMgr/Src/Sm/Ph/Mt/ClassReader.cpp?view=diff&rev=427&p1=branches/3.2.x/Utilities/SchemaMgr/Src/Sm/Ph/Mt/ClassReader.cpp&r1=426&p2=branches/3.2.x/Utilities/SchemaMgr/Src/Sm/Ph/Mt/ClassReader.cpp&r2=427
File: branches/3.2.x/Utilities/SchemaMgr/Src/Sm/Ph/Rd/Join.cpp https://fdocore.osgeo.org/source/browse/fdocore/branches/3.2.x/Utilities/SchemaMgr/Src/Sm/Ph/Rd/Join.cpp?view=diff&rev=427&p1=branches/3.2.x/Utilities/SchemaMgr/Src/Sm/Ph/Rd/Join.cpp&r1=426&p2=branches/3.2.x/Utilities/SchemaMgr/Src/Sm/Ph/Rd/Join.cpp&r2=427
File: branches/3.2.x/Utilities/SchemaMgr/Src/Sm/Ph/TableComponentReader.cpp https://fdocore.osgeo.org/source/browse/fdocore/branches/3.2.x/Utilities/SchemaMgr/Src/Sm/Ph/TableComponentReader.cpp?view=diff&rev=427&p1=branches/3.2.x/Utilities/SchemaMgr/Src/Sm/Ph/TableComponentReader.cpp&r1=426&p2=branches/3.2.x/Utilities/SchemaMgr/Src/Sm/Ph/TableComponentReader.cpp&r2=427



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