Subject RES: [firebird-support] Cache a table
Author Fabiano - Desenvolvimento SCI

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: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Em nome de julien.ferraro@...
Enviada em: quarta-feira, 16 de outubro de 2013 11:31
Para: firebird-support@yahoogroups.com
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