Specifying cache expiration for virtual tables

You can also schedule caching to retrieve table records from cache rather than from the real data source. It makes the work with such tables faster. Specify the cache settings properly to use only relevant data in tables.

1. On the third page of the New Virtual Table wizard, select the Use expiration schedules check box.
   The schedule expiration settings become available.
2. From the Default expiration schedule list, select the schedule that you want to use as the default one for the whole virtual data source.
   Note: To add more schedules, consult the QMF administrator.
3. To assign a particular cache expiration schedule to the table, click the Schedule name column of the table, the settings of which you want to modify, and select the required schedule from the list of available ones.
   Note: If tables contain any substitutional variables, only Always Expired expiration schedule is applied to such tables.
4. If your source table requires authorization for accessing it, you must specify the authorization settings for the virtual table. Click the Manage Authorization button.
   The Manage Authorization window opens. All the data sources that require authorization are listed there. This authorization data is used for updating the cache.
5. Click the Login column for the required data source.
   The Edit Data Source Login dialog opens.
6. Enter the proper values in the Login and Password fields and click OK.
7. When you finish specifying authorization data for all required data sources, click OK in the Manage Authorization dialog.
8. Click Finish to close the wizard.