SQL Power Software Forum

When working with large databases, with lots of schemes, It would be very nice to have a box listing all the available schemes and allowing the user to select which of the schemes shall be loaded, instead of trying to load all the available schemes and tables from the source database.

An example:

Suppose a database with 10 users: USER_1, USER_2, ..., USER_10
and 10 schemes, SCHEME_1, SCHEME_2, ..., SCHEME_10.

I'm connecting with user USER_1 which shall access tables of SCHEMES SCHEMA_1, SCHEMA_2 and SCHEMA_3 only.

In this session, I'm focused on working/modeling the tables present in SCHEMA_1, but i really do not care of the contents of SCHEMA_2 or SCHEMA_3 at this moment.

My suggestion is that at the database connection screen it shall be possible to optionally select the desired schemes to work with. (connect, load the schemes names and allow the user to select one or more of them to do a pre-load.

The others may also appear in the db tree pane, but may be grayed, to indicate they are not loaded. Another option is to only show the schemes selected at the beginning. Either of the two approaches would greatly improve the initial load of the database tables, that sometimes is too much slow doe to slow connections to the database server.

Any comments/doubts, please contact me.

PS.: This is a great product!