Making large table views memory-resident can dramatically improve performance. To make a table view memory-resident, ensure the following:
• It is read-only.
AND
• You always specify the same filter condition for this table view or no condition at all (filter condition will take effect only once for the application, in the first Fill).
In the Schema Designer, open the data set containing the table view, select the table view on the Diagram tab, select MemoryResident property in the property grid below, set MemoryResident = True. This is all that is needed to make a table view memory-resident.
|
