Subject | RES: [firebird-support] Cache a table |
---|---|
Author | Fabiano - Desenvolvimento SCI |
Post date | 2013-10-16T18:16:03Z |
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