Preprocessing and buffer tables

[Former Member]

Hello!

Does somebody knows the differnce between preprocessing und buffer tables?

In which context are they used?

Thanks for your help!

[Former Member]

Buffering tables means,

inorder to reduce the traffic between Database sever and application server, this technic is used.

if the table is buffred means, that will be fetched from the database once, and the results are stored in application server, when again these results are required, they can be retrieved from the App server, not from DB server, hence can reduce the traffic.

Normally buffering can be used to the tables, whose contents will not be changed frequently.