Why a foreground write in Informix decrease performance?State the reason for the same?

Questions by GregMark   answers by GregMark

Showing Answers 1 - 3 of 3 Answers

jayanta.js

  • Apr 14th, 2008
 

foreground writes (FG) should always be zero. A foreground write is caused when a session needs to have a page from disk placed into the buffer pool, but there are no clean/free buffers available. In this case, the sqlexec thread will pick a page off the least recently used side of an LRU queue, write it out, and mark the page as clean. This process is time consuming for a session and should be avoided.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions