""Ann W. Harrison"" ...

> Rick Debay wrote:
> > Does backup effectively flush the page cache due to it reading every
> > record? How about sweep?
>
> Yes to both. Anything that reads the whole database will flush
> the cache.

Sorry, this is not quiet so. All natural table scans not flushed page cache.
It is done by queueing page buffer at the end of LRU chain after release.
Perhaps it was added in IB6.

Note that file system cache flushed anyway.

Regards,
Vlad