Applies to
TQDB, TQDBItem, TQDBView
Declaration
property CacheFrequency : integer;
Description
The CacheFrequency property (which has been superceded by the CacheStatistics method) returns the percentage of item-requests that are serviced by the internal item-cache rather than by reading from the disk. Values range from 0 (when every item has been fetched fresh from the disk) to 100 (when all requests have been honored by the cache).
CacheSize can be adjusted until CacheFrequency hits some appropriately high value indicating high performance. Remember though that a very large cache both consumes memory and has its own performance overhead.
CacheFrequency is reset automatically whenever CacheSize is changed but can also be reset manually by assigning it the value zero, i.e.:
CacheFrequency := 0;
N.B.: You really do need to check whether item-cacheing actually improves performance on your system. The default system disk-cache may be good enough to do away with any item-cacheing benefits.