To display stored procedure information, Enterprise Explorer must access the database on which the stored procedures reside. Fetching information from a database containing many stored procedures can result in a long display latency.
To accelerate the display time for databases with many stored procedures, use the subgrouping preferences option. This option groups stored procedures into units of specified size. Enterprise Explorer displays information for stored procedures in each unit as it is demanded, while information for stored procedures in other units is retrieved in a background process.
The background process must complete before you can perform operations involving the stored procedures or the database on which they reside.
To set Subgroup Stored Procedures preferences:
Select Window|Preferences from the main menu bar.
The Preferences dialog box appears.
In the left pane, expand Sybase, Inc and select Enterprise Explorer | Database Connection Profile.
Modify the following fields to specify subgrouping behavior.
Select the check box to have stored procedures displayed under a group node in Enterprise Explorer. Grouped stored procedures are displayed by name in alphabetical order.
Enter a number in the text field to specify the number of stored procedures per group. The default is 25. If there are fewer stored procedures than specified here, the stored procedures are not grouped in Enterprise Explorer.
Setting Database Development Preferences
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com