Optimizing View Performance

  • Article

You can optimize your views by setting data fetching and performance options. Use the Advanced Options dialog box to fine tune how records are retrieved in a view or how updates are made to the server or source tables.

To set advanced options

  1. From the Query menu, choose Advanced Options.
  2. In the Advanced Options dialog box, set the connection information and data fetching options you need.
  3. Choose OK.

Controlling Progressive Fetching Fetch Size

You can control the number of rows Visual FoxPro progressively fetches at one time from the host database with the FetchSize property of the view and the active view cursor. You use DBSETPROP( ) and CURSORSETPROP( ) to set these properties.

Controlling Memo Fetching

You can use the delayed memo-fetching feature to speed retrieval of view data. When you choose delayed memo fetching, Visual FoxPro does not retrieve the contents of a Memo field until you choose to open and display the field. Because Visual FoxPro needs the key field and table name to locate a row on the remote data source, you must set the UpdateName or UpdateableFieldList property, the KeyField or KeyFieldList property, and the Tables property for delayed Memo fetching to work. However, you don't have to set the SendUpdates or Updateable properties to on in order to make delayed memo fetching work.

See Also

Updating to Online Data | Setting the Maximum Number of Records Downloaded | Creating Queries | Optimizing Filters and Joins | Sharing Connections for Multiple Remote Views | Advanced Options | DBSETPROP( ) | CURSORSETPROP( )