Opened 16 years ago

Closed 16 years ago

#147 closed defect (fixed)

DescribeSchema slow for config files and datastore with foreign keys and views.

Reported by: brentrobinson Owned by: brentrobinson
Priority: major Milestone: 3.3.0
Component: FDO API Version: 3.3.0
Severity: 2 Keywords: config performance DescribeSchema
Cc: External ID:

Description

When a non-FDO datastore is opened using a config document, the DescribeSchema command is slow if the datastore has a lot of views or foreign keys.

Change History (8)

comment:1 by brentrobinson, 16 years ago

Status: newassigned

comment:2 by brentrobinson, 16 years ago

Revision: 3487 Author: brentrobinson Date: 11:24:43 AM, Thursday, October 25, 2007 Message: Ticket#147: Avoid foreign key queries for association properties loaded from config doc. Allow bulk loading of view dependencies when FDO connection uses config doc.


Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Common/FdoImportExportTest.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Common/FdoImportExportTest.h Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Common/SchemaMgrTests.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Common/SchemaMgrTests.h Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Common/UnitTestUtil.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Common/UnitTestUtil.h Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/gen_default1_Oracle_master.txt Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Lp/SchemaElement.h Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/Owner.h Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Lp/AssociationPropertyDefinition.cpp Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/Owner.cpp

comment:3 by brentrobinson, 16 years ago

Revision: 3514 Author: brentrobinson Date: 1:35:45 PM, Tuesday, October 30, 2007 Message: Ticket#147: improved schema deserialization performance.


Modified : /trunk/Fdo/UnitTest/schema_uns_high_master.txt Modified : /trunk/Fdo/Unmanaged/Src/Fdo/Schema/SchemaFromExternal.h Modified : /trunk/Fdo/Unmanaged/Src/Fdo/Schema/SchemaFromExternal.xslt Modified : /trunk/Fdo/Unmanaged/Src/Fdo/Xml/Deserializable.cpp

comment:4 by brentrobinson, 16 years ago

Revision: 3556 Author: brentrobinson Date: 11:43:43 AM, Wednesday, November 14, 2007 Message: Ticket#147: Reduced the number of indexes that are bulk loaded to those actually needed for reverse-engineering schemas


Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/gen_default1_Oracle_master.txt Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/DbObject.h Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/Owner.h Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/Table.h Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/DbObject.cpp Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/Owner.cpp Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/Rd/ClassReader.cpp Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/Table.cpp

comment:5 by brentrobinson, 16 years ago

Revision: 3596 Author: brentrobinson Date: 2:40:25 PM, Tuesday, December 04, 2007 Message: Ticket#147: Moved setting active spatial contexts out of connection open, in preparation for optimizing spatial context retrieval.


Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Lp/SpatialContextCollection.h Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/Owner.h Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/SchemaManager.h Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Lp/SpatialContextCollection.cpp Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/Owner.cpp Modified : /trunk/Utilities/SchemaMgr/Src/Sm/SchemaManager.cpp

comment:6 by brentrobinson, 16 years ago

Revision: 3606 Author: brentrobinson Date: 7:49:56 AM, Monday, December 10, 2007 Message: Ticket#147: Reduced memory allocations


Modified : /trunk/Fdo/Unmanaged/Inc/Common/StringP.h Modified : /trunk/Fdo/Unmanaged/Src/Common/StringP.cpp

Revision: 3607 Author: brentrobinson Date: 12:03:52 PM, Monday, December 10, 2007 Message: Ticket#147: Added support for incrementally reverse-engineering spatial contexts.


Modified : /trunk/Providers/GenericRdbms/Src/Fdo/FeatureCommands/FdoRdbmsSelectCommand.cpp Modified : /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Lp/SchemaCollection.cpp Modified : /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Lp/SchemaCollection.h Modified : /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/SchemaManager.cpp Modified : /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/SchemaManager.h Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Lp/SchemaCollection.cpp Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Lp/SchemaCollection.h Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/SchemaManager.cpp Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/SchemaManager.h Added : /trunk/Providers/GenericRdbms/Src/UnitTest/spatial_contexts1_master.txt Added : /trunk/Providers/GenericRdbms/Src/UnitTest/spatial_contexts2_master.txt Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Lp/SchemaCollection.h Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Lp/SpatialContextCollection.h Added : /trunk/Utilities/SchemaMgr/Inc/Sm/Lp/SpatialContextMgr.h Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/Mgr.h Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/Owner.h Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/SchemaManager.h Modified : /trunk/Utilities/SchemaMgr/LogicalPhysical.vcproj Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Lp/GeometricPropertyDefinition.cpp Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Lp/Makefile.am Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Lp/SchemaCollection.cpp Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Lp/SpatialContextCollection.cpp Added : /trunk/Utilities/SchemaMgr/Src/Sm/Lp/SpatialContextMgr.cpp Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/Mgr.cpp Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/Owner.cpp Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/SpatialContextCollection.cpp Modified : /trunk/Utilities/SchemaMgr/Src/Sm/SchemaManager.cpp

comment:7 by brentrobinson, 16 years ago

Revision: 3608 Author: brentrobinson Date: 1:16:20 PM, Monday, December 10, 2007 Message: Ticket#147: Fixed memory leak introduced by revision 3606. Also tuned the "+=" operator


Modified : /trunk/Fdo/UnitTest/CommonTest.cpp Modified : /trunk/Fdo/Unmanaged/Inc/Common/StringP.h Modified : /trunk/Fdo/Unmanaged/Src/Common/StringP.cpp

comment:8 by brentrobinson, 16 years ago

Resolution: fixed
Status: assignedclosed
Note: See TracTickets for help on using tickets.