Firebird vs Windows: file-system caching issue

This article, from Dmitry Yemanov, is a must read for everyone using Firebird on more recent Windows versions, specially Windows 2008. As some people already experienced, it seems that the Windows Cache Manager intelligence in those versions of Windows are not smart enough, and can produce very bad performance for database access in some circumstances.