Dropping Error Marts takes a long time when resetting a project.
Since updating to the August release of Compose for DW, the "dropping error marts" operation takes a long time to complete when resetting a project. In my case, there aren't even any error mart tables to drop...
Has anyone else seen this behavior? Is it a bug?
Our target is SLQ Server and a SQL Profiler trace shows that compose is running the same two queries over and over:
SELECT SCHEMA_NAME (uid) AS ownerName ,name AS tableName FROM sysobjects WITH (NOLOCK) WHERE type = N'U' AND (category = 0 OR category = 32) AND OBJECTPROPERTY (id, 'IsSystemTable') = 0 AND name <> N'sysdiagrams' AND SCHEMA_NAME (uid) = 'EM';
EXEC sp_executesql N'select TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, CHECK_OPTION, IS_UPDATABLE from INFORMATION_SCHEMA.VIEWS where (TABLE_CATALOG = @Catalog or (@Catalog is null)) and (TABLE_SCHEMA = @Owner or (@Owner is null)) and (TABLE_NAME = @Table or (@Table is null)) order by TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME' ,N'@Catalog nvarchar(4000),@Owner nvarchar(2),@Table nvarchar(4000)' ,@Catalog = NULL ,@Owner = N'EM' ,@Table = NULL;