When you reduce the number of cached databases, SQL is more likely to have to pull information for databases from disk, which is slower. Reduce the number of databases cached in memory.However, this means that you will not be able to take full advantage of all of SQL Prompt's features.
If you are unable to upgrade your PC, you can change your options and settings to reduce memory usage, as follows. If you want to take full advantage of the features that SQL Prompt offers, you are recommended to upgrade your PC to increase the amount of physical memory to a minimum of 1 GB for very complicated schemas, 2 GB may be required. If you have insufficient RAM installed in your PC, the performance of Windows and all your applications may degrade because the operating system has to swap data in and out of memory, onto disk and back again. If you use SQL Prompt with a database that has a complicated schema, you may experience some performance issues because of the amount of memory that SQL Prompt needs to use. Using SQL Prompt with databases with complicated schemas You may also wish to clear the Enable cross-database and linked server support check box on the Listed Candidates, Cross-Database Support options page. On the Cache Management dialog box, set the Maximum number of databases to hold in memory to 3.
If you are using SQL Prompt with databases that contain several thousand objects and you are experiencing very high memory usage, you are recommended to set the SQL Prompt options on the Listed Candidates, Candidate Types and Filters options page as follows: databases that contain a large number of objects.This topic provides information to help you to optimize SQL prompt for use with: