I think you are running at the wrong direction. Why are you wanting to cache those data? Are your having performance problems?
The only way I know you can do what you want is create a exclusive connection (By the way: Classic Server) to the FB server and ONLY execute select statements in those tables – Customer, CustomerAddress, etc. In that way database cache pages for that connection will stay only on those tables. Another approach is using for example Delphi´s DataSnap technology. You will cache that data in your DS server and synchronize with Firebird database. Let me know more about your problem. De: [email protected] [mailto:[email protected]] Em nome de [email protected] Enviada em: quarta-feira, 16 de outubro de 2013 11:31 Para: [email protected] Assunto: [firebird-support] Cache a table 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 ? Many thanks in advance, Julien
