Slow Consoles

If you are running into consoles that are running slow, there are a few items to review and fix:1. LOAD ON OPEN:  Open form in Design View and search for LoadOnOpen. Try to eliminate the number of listviews and grids that are set to LoadOnOpen by replacing these with .Refresh on a button action instead.Some items don't need to be displayed when the form automatically opens - they don't need to be displayed until a user clicks a button to navigate to another location instead.2. CLIENT LISTS:  Are there enough client lists for the number of listviews on the console? Instead of using one client list and auto refreshing all other controls based off of this one list, consider adding additional client searches for other tabsheets. If possible you should have one client list per tab.  This will eliminate the number of items that refresh each time a new client is selected. 3. CLIENT DOCID:  When selecting the max docid for a client, do not display all items and sort in decending order, instead, use a sql query to select the max(op__docid) instead.4. ORGANIZED CONSOLES;  Consider eliminating some of the items on a console - if two different groups of users use the console, consider removing some tabs and creating a second console instead.5. PROFILER:  Turn on SQL Profiler and identify long running queries and stored procedures. Also pay attention to queries being run, maybe listviews are still refreshing when they shouldn't.