Progress
DataServer for
Microsoft SQL Server
Guide
Local Schema Caching
By using a local file to store schema definitions, you can access them more quickly. Running DataServer applications with a local schema cache can result in better performance in networked environments.
The Progress 4GL SAVE CACHE COMPLETE statement creates a binary file that contains the entire schema for a Progress database. Use this statement to create a cache file for a connected schema holder:
For example, the following statement creates a cache file named
sqlcache
for the sqlhold schema holder:
To use the cache file specify the Schema Cache File (-cache) startup parameter and the cache filename when you connect to the schema holder. For example, the following CONNECT statement connects a SQL Server™ database whose data source name is sqlserv1 with the schema sqlhold and tells Progress to use the cache file:
If you make any changes to a schema holder, you must create a new cache file for it. For more information, see the Progress Programming Handbook and the SAVE CACHE Statement reference entry in the Progress Language Reference.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |