WinSQL » Knowledge base
Document information
Document ID: | 810 |
---|
Subject: | Fetching database catalog - takes very long |
---|
Creation date: | 7/29/09 4:39 PM |
---|
Last modified on: | 12/12/18 10:14 AM |
---|
Details
After establishing connection to the database, WinSQL tries to
fetch the database catalog. On larger databases, with thousands of
tables, this may take a very long time. Therefore, it is recommended
that you turn this feature off. Following steps show you how to do
that.
Version 6.5 or higher
Using cache is no longer a global option in version 6.5. You can enable or disable catalog fetching per connection.
Steps:
- Start WinSQL - Connection window is displayed
- Un-check "Enable catalog caching"
- Un-check "Load catalog after connection"
Note: If catalog caching is enabled, WinSQL will always load the catalog from the last saved cached value.
|
|
Version 6.0 or belowEnabling or disabling
catalog fetching is a global option. This means if you disable it, WinSQL
won't fetch the catalog for every connection.
Steps:
- Start WinSQL
- Click the Cancel button in the connection window
- Click Edit/Options on the main menu
- Uncheck Fetch catalog after connection
- Reconnect to you database
|
|
Refer to the image below, which is a screen shot of WinSQL version 6.5. Connection window for newer versions look similar.

Disadvantage of disabling catalog
Features that depend on the catalog won't work until the catalog is fetched. These features are:
- Intelli-Tips
- Drill down results
To decrease the amount of data returned in the catalog window, try specifying a particular schema/user in the catalog window.
User comments
Posted by MR on 2/14/18 12:34 PM
Please stop automatically fetching the catalog. It is useless for many of us. Give us the option to completely turn it off
Posted by Giridhar Alamuri on 3/23/17 11:08 AM
I have the lite version of the software (version number 10.0.193.733) and there are no options on a generic ODBC driver for caching the catalog and it does not make a difference whether the "Fetch catalog asynchronously" is checked or not. It still downloads the catalog and the connections is slow.
Posted by Satya on 8/23/18 4:50 PM
Though I uncheck "load catalog after connection", winsql is trying fetch catalog. I have latest version as of today.
Posted by Satya on 8/23/18 4:52 PM
Though I uncheck "load catalog after connection", winsql is trying fetch catalog which is never expected. This is hanging winsql to use. I have latest version as of today. Does anyone know how to get this fixed ?
Add a comment to this document
Do you have a helpful tip related to this document that you'd like to share
with other users?
Important: This area is reserved for useful tips. Therefore, do not post any questions here. Instead, use our
public forums to post questions.