BitFarmer

I see, I am actually suffering from something similar but even worst: In FreeIB -we still use it, a "enhaced" version of our own- is the same: Tables are cached, queries are not, but with 2 differences:

1) Cache is made in contigous memory for all the table, so never reach the memory limit (at about 45MB it crashes).

2) Queries use a slighty different TColumn class, so replacing tables with queries is not straight forward.

Some day we will have to change components, but our app is so so big it scare us a bit!