SQL Prompt stores information about the structure of databases in cache files. Using cache files speeds up performance when SQL Prompt retrieves information about a database.
SQL Prompt creates a cache file for each database that you use. The cache files are encrypted and stored in your local settings on your computer; SQL Prompt can read only the cache files that were created by your Windows® user.
Note that SQL Prompt does not create cache files for databases you have chosen to ignore.
To manage the cache files, on the SQL Prompt menu, click Cache Management.
Refreshing cache files
If the structure of a database has been modified, for example if a table has been added to the database, you can refresh the cache files so that the changes are shown in the candidate list. SQL Prompt updates the cache files ready for you to use immediately.
To refresh the cache file for the database you are using in your query editor, on the SQL Prompt menu, click Refresh Cache, or press CTRL+SHIFT+D.
You can set SQL Prompt so that it refreshes cache files whenever you open a new query editor instance. You do this by selecting the check box on the Cache Management dialog box.
To refresh selected cache files, on the Cache Management dialog box, select the databases for which you want to update the cache, and then click Refresh.
To refresh all cache files, on the Cache Management dialog box, click Refresh All. The Caching Progress bar shows the progress of the refresh. This process may be time-consuming if you have many databases cached, or if you have large databases cached. However, you can close the Cache Management dialog box and continue working while the cache is refreshing.
Note that if a database is being restored or it is offline, you cannot refresh its cache file.
Deleting cache files
You may want to delete cache files, for example to create disk space. If you delete the cache file for a database, SQL Prompt creates a new cache file the next time you use the databases in your query editor.
To delete individual cache files, on the Cache Management dialog box, select the databases for which you want to delete the cache, and then click Delete.
To delete all the cache files, on the Cache Management dialog box, click Delete All.
Maximum number of databases to hold in memory
You can change the number of databases to be cached. For example, you may want to increase the number if you are using cross-database support and you regularly query a number of different databases.
However, note that caching databases increases memory usage, so if your memory usage is high you may want reduce this number.
The minimum value for this option is 3.
© Red Gate Software Ltd 2007. All Rights Reserved.