Database Explorer Cache

I'm trying to use SQL Editor more, it's lighter weight than SSMS by a fair margin.

One of the things stopping me is every time I re-open Database Explorer and drill down to the dbo schema to get to my DB tables, it takes a good 30s before I get an expanded view for Tables/Views/Functions/Procedures/Synonyms.

Is there any way to cache this data? I suppose it does once you open the schema once (per session?) .. but I find myself closing out of the editor often and re-opening it later to bang out another quick query.

This may be related to the search slowness. I see this was never touched on in this post.

You should profile execution of Schemas and Objects queries from SQL Assistant options. In theory it could be caused by slow database server catalog queries. A Schema query Schemas (MSSQL) in a database with thousands of tables should come back in a fraction of a second. An Objects query, by default that is Objects (MSSQL) + Typed Synonyms should come back in under several seconds, . It should not take 30 seconds.

Please run the Schemas query first, replace placeholders and bind parameters with some values and time it. After that run the Objects query and time it too. Please share your results.

This issue should be related to http://www.softtreetech.com/support/phpBB2/viewtopic.php?t=24633

Please turn off extended information and see if that makes a big difference.

	SysOp wrote:
	This issue should be related to http://www.softtreetech.com/support/phpBB2/viewtopic.php?t=24633 Please turn off extended information and see if that makes a big difference.

Yes, massive difference.