‎2007 Oct 29 5:38 AM
when can we buffer the table? is there any disadvantes in buffer table?
Regards,
pandu.
‎2007 Oct 29 5:41 AM
Hi Pandu,
It is again on your requirement. There is no disadvantage but you should buffer the table only if you think the table will be queried very often and the contents will not change much often.
Regards,
Atish
‎2007 Oct 29 5:44 AM
‎2007 Oct 29 5:54 AM
Hi pandu,
why do you want to buffer that is more important.
As this table is very oftenely used but also oftenly updated so not recommended.
Regards,
Atish
‎2007 Oct 29 5:58 AM
‎2007 Oct 29 5:51 AM
Hi,
We can use buffering but we have to see that if the table is having large number of records then buffering is not to be used as it takes a lot of memory. If the table contains mediuum range to small range of records and if it is used frequently then it is preffered to buffer the table.