[SA 9.0.162 Pro] Lockups searching in Database Explorer

	Mindflux wrote:
	How do you delete the FTS repo? I'll do that tomorrow and see if my lockups return.

1. SQL Assistant > Search & Replace > Context SQL Search
2. Right click into the listbox and select Reset FTS code Repository.

It appears there is indeed a database retrieval involved if show extended object information option is enabled. It pulls comments and some other object and column attributes from the database which are not cached. Disabling that option and restarting the editor should speed up the tree filtering. My apologies for misleading you earlier. I wasn't aware of that dependency.

Hmm, it didn't even require editor restart. Got lightning fast immediately...

	SysOp wrote:
	It appears there is indeed a database retrieval involved if show extended object information option is enabled. It pulls comments and some other object and column attributes from the database which are not cached. Disabling that option and restarting the editor should speed up the tree filtering. My apologies for misleading you earlier. I wasn't aware of that dependency.

Are you talking about "Show Extended Properties" under Hide/Show in database explorer?

If so that definitely helped.

Perhaps this shouldn't be default enable?

Exactly what I had on my mind.