PERFORMANCE DURING TABLE ACCESS XIII

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.


RELATED POSTS

0 comments:

Post a Comment

Content

Privacy Policy

The articles are copyrighted to Technical Information and can only be reproduced given the author's permission.Information furnished in the blog is collected from various Resources.This blog does not host any files on its server. Please report any broken links in comment. If u have any queries contact me at technicalinformation.websites@gmail.com