Tom Conlon wrote:

> In testing different queries and their performance is it possible to
> sometimes clear the DB cache (when required) to exclude its effect?

I suppose you use SuperServer?

In that case, you can simply restart Firebird. But, if you use Linux,
the filesystem will still cache the part of hard disk which it read (if
database file is small, it could easily cache the entire file), so the
only way is to 'read' enough of other data to overwrite that. Copying a
DVD image file could take care of that if you have 4GB RAM. AFAIK, other
than that, only restart or the machine helps.

--
Milan Babuskov
http://fbexport.sourceforge.net