SqlDbx Forum

des

Member

Time taken to change database

It takes longer to change database context using the drop-down menu, compared to executing 'USE <dbname>' statement.

Is this normal? I think it may be related to the loading of tables, etc information displayed on the left side of the program. Is there any way to disable this entirely?

Also, the drop-down menu and objects do not update accordingly when changing database context via USE statement.

Last edited by des (2008-12-30 21:18:47)

sqldbxhelp

Administrator

Re: Time taken to change database

To make database context switch faster go to Options->Servers->Sybase and uncheck "Display table rows" check box.
You are correct that issuing USE statement does not affect object list on a left. This is by design. The left side shows the
objects from database selected in drop down box. Current database is displayed on a status bar.