Subject Re: [firebird-support] Cache a table
Author Thomas Steinmaurer
> Hello,
> I would like to cache a few tables (Customer, CustomerAddress, ...) from
> my database so the query to this table are fast.
> I will change the cache size so the tables fit into memory.
> I have some huge tables in the database (Invoice, InvoiceLine, ...) And
> I don't want every query to those tables to remove the Customer tables
> from memory.
> What is the correct way to accomplish this task ?

There is no way to tell Firebird to pin a particular table in the page
cache. I wonder what huge means in your context. With proper SQL and an
index strategy in place, response time should be fine.

With regards,
Thomas Steinmaurer

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.