Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Configure Options > Database > Cache

Cache Options

This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To set cache options

Review the following for additional information:

Volatile Cache	Description
Current in-memory size	Displays the memory cached for your current session.
Maximum in-memory size	Enter the maximum memory to cache for your current session. Default: 10 MB
Enable cache overflow to disk	Allow cache to be stored in persistent cache (to disk) if you exceed the maximum in-memory size. Default: Cleared
Object Annotation Cache	Description
Private folder	Saves the following information to an XML file on the client: User-defined notes on objects, Query Builder files, or ER diagrams. See Add Notes for more information. Lookup tables for Query Builder files or Database diagrams. See Find Lookup Tables for more information. Hidden columns of data. See Show or Hide Data for more information.
Share object annotations	Creates a Microsoft Access database named QuestShared.mdb to store shared notes and lookup tables between users.
Share hidden column settings	Shares any hidden columns of data with other users.
Notes: Object Annotation Cache does not save the actual objects, Query Builder files, ER diagrams, or data files associated with the notes, lookup tables, or hidden columns. You can share projects that contain objects and files by specifying a Network Share location. See Network Share Options for more information. To use shared annotation cache, users must have access to the objects or files.

Tips:

To clear cache memory for the current session, click Clear Cache.
To navigate to the directory where option settings are stored, click the Application Data Directory link in the About dialog (Help | About).
To search for a partial or complete option name or value, use the Search field at the bottom of each Options page. See About Options for more information.