LESSON 13 PERFORMANCE DURING TABLE ACCESS

PERFORMANCE DURING TABLE ACCESS:


Advantages and disadvantages of the method of buffer synchronization:
Ÿ
Advantage:

The load on the network is kept to a minimum. If the buffers were to be synchronized immediately after each modification, each server would have to inform all other servers about each modification to a buffered table via the network. This would have a negative effect on the performance.


ŸDisadvantage :

The local buffers of the application servers can contain obsolete data between the
moments of synchronization.

This means that:
Ÿ
Only those tables which are written very infrequently (read mostly) or for which such temporary inconsistencies are of no importance may be buffered.


Ÿ Tables whose entries change frequently should not be buffered. Otherwise there would be a constant invalidation and reload, which would have a negative effect on the performance.