[SA 7.1.228 Pro] Loading all objecs while comparing some

[SA 7.1.228 Pro] Loading all objecs while comparing some

While using compare schema feature, SA loads all objects even if only some are selected.
For example comparing functions, loading other objects is indicated by status bar.

Is it intended to be like this?

Not intended, unless the extra objects are returned by the same queries, in which case they are filtered at a later stage.

Would you please provide a specific example demonstrating what you're seeing?

I just wanted to compare functions. See screenshot.
But also aggregates, columns, foreign keys, indexes, triggers and more are loaded.
Also I noticed, some objects are loaded twice (based on names shown by status bar)

By the way, we are working on supporting more types of PostgreSQL objects and options. A new beta build is expected this week, it should have more of that stuff available.

	Quote:
	I just wanted to compare functions. See screenshot. But also aggregates, columns, foreign keys, indexes, triggers and more are loaded. Also I noticed, some objects are loaded twice (based on names shown by status bar)

I think it loads all schema objects the filters them per selection. The reason for a second pass in some cases is evaluation of dependencies and some other things required for generation of schema synchronization scripts.

But loading all objects is waste of resources I believe. I know it's not major case. I noted that just for any case, some thing gone wrong.

1. It's first beta for the schema compare, we still need to identify the issues, and your feedback is very helpful.
2. Certain things are done for technical reasons beyond efficiency. I agree for efficiency they could have been done differently, but there could have been the technical constraints causing dev team to choose not the most efficient method.