Opened 16 years ago

Closed 14 years ago

#282 closed enhancement (fixed)

Improve performance for DescribeSchema from multiple datastores

Reported by: brentrobinson Owned by: brentrobinson
Priority: minor Milestone: 3.4.0
Component: SQLServer Spatial Version:
Severity: 3 Keywords: Describe Schema Performance Views
Cc: External ID:

Description

DescribeSchema can be slow when the datastore has views based on tables from other datastores. The reason for this is that, when the base tables are retrieved, they are fetched one at a time.

This enhancement will ensure that these base tables are bulk fetched.

Change History (3)

comment:1 by brentrobinson, 16 years ago

Status: newassigned

comment:2 by brentrobinson, 16 years ago

Revision: 3831 Author: brentrobinson Date: 1:14:53 PM, Thursday, March 27, 2008 Message: Ticket#282: Bulk load base tables from other datastores.


Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/GroupReader.h Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/Owner.h Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/BaseObject.cpp Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/Owner.cpp

comment:3 by brentrobinson, 14 years ago

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