Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

FIX: Slow View Performance with Sybase ODBC Driver

View products that this article applies to.

This article was previously published under Q196773

↑ Back to the top


When you create a view with either the View Designer or with CREATE SQL VIEW and using a Sybase ODBC driver to connect to a Sybase server, the view performance can be slow when you are working with large tables.

↑ Back to the top


Step-by-Step Procedures

  1. Open the ODBC Manager from the Control Panel.
  2. Double-click on the Sybase DSN for the connection that will be used in Visual FoxPro.
  3. Click the Advanced tab, and click Performance.
  4. Set the Prepare Method to None (default is Full).

↑ Back to the top

More information

Steps to Reproduce Behavior

  1. Install the Sybase ODBC driver.
  2. Create a Sybase datasource that connects to a database with a table of at least 100,000 rows.
  3. Open a Visual FoxPro database. Use MODIFY DATABASE to open the Database Designer. Right-click on the Database Designer window and click Connections. Click New and create a connection based on the Sybase datasource.
  4. Right-click on the Database Designer window and click New Remote View...
  5. Click New View in the New Remote View dialog box. In the following dialog box, select the connection created in step 3.
  6. When the dialog box opens with a list of tables, select a table with at least 100,000 rows.

    NOTE: Depending upon the size of the table, the View Designer might take several minutes to respond.
Sybase is manufactured by Sybase, a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

(c) Microsoft Corporation 1998, All Rights Reserved. Contributions by Mike Stewart, Microsoft Corporation.

↑ Back to the top

Keywords: KB196773, kbfix, kbdatabase, kbbug

↑ Back to the top

Article Info
Article ID : 196773
Revision : 3
Created on : 3/7/2005
Published on : 3/7/2005
Exists online : False
Views : 336