cache table
I read a previous post after a search on "cache table" on this site.
The conclusion was that one should not cache large tables to memory,because it will flood it.Use cache for small tables
My problem:My "application data viewer" uses 3 distinct large tables(large:blocks>4000)
on a regular basis. The i/o and buffer usage is expensive.
Question 1:Will the caching of these 3 tables in memory(Keep) NOT improve the performance of my apps.data viewer.
(The availability of memory is not a big issue)
Question 2:Should i rather cache meta tables(small) to mem.for performance improvement.
Please advise
thanx in advance
Able was I ere I saw Elba