InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Why Do Foreground Writes Decrease Performance ? |
|
Answer» Whenever Informix sqlexec process searches for a free / clear buffer in ORDER to read a page from the disk into that buffer is called foreground write operation. The performance penalty appears when there are no free / CLEAN buffers left, and sqlexec has to search for a LESS USED buffer, write its content to disk, clean the buffer and reuse the buffer for a foreground write operation – having the DISADVANTAGE of NOT being asynchronous (as chunk writes/lru writes) Whenever Informix sqlexec process searches for a free / clear buffer in order to read a page from the disk into that buffer is called foreground write operation. The performance penalty appears when there are no free / clean buffers left, and sqlexec has to search for a less used buffer, write its content to disk, clean the buffer and reuse the buffer for a foreground write operation – having the disadvantage of NOT being asynchronous (as chunk writes/lru writes) |
|