Asynchronous Catalog Fetching

By definition, “caching” means to use a temporary storage area to house frequently-accessed data, thereby decreasing access time. Upon connection to your database, WinSQL provides the option of automatically creating a cached version of your database catalog in memory. Caching your database catalog reduces the amount of time it takes to fetch metadata information from the back-end database, which greatly increases access time to your data.

When asynchronous catalog fetching is enabled, WinSQL fetches the entire database catalog using a secondary thread. This thread also creates a secondary database connection to the back-end, which is then used to fetch the metadata.

Synametrics recommends disabling this option IF:

·You are connecting to a very small database

·Database connections are limited

Enabling Asynchronous Fetching

Click Fetch catalog asynchronously at the time of connection, depicted as follows:

Notes:

·If Fetch catalog asynchronously is selected at connection, WinSQL will establish a second connection to the database and fetch the catalog in a secondary thread.

·You will see one of three images in the status bar, depicted as follows.

A “C” displays in green once the catalog is completely fetched, indicating catalog fetching is complete.

An “A” in blue displays indicating WinSQL is fetching the catalog in the background.

A “D” in grey indicates asynchronous fetching was not used for this connection.