> 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
http://www.upscene.com/

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