> 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.
