Interested to Buy Any Domain ? << Click Here >> for more details...
explain checkpoints and why in 9.4 they were better than in previous versions of the engine?
- 1 Answers
- 72 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / Manindra Nath Singh
Checkpoints are a mechanism used to write dirty pages from the system cache to disk, ensuring data consistency during recovery or crashes. In Informix 9.4, checkpoints were improved due to the implementation of 'Adaptive Checkpointing'. Unlike previous versions where checkpoints occurred at fixed intervals regardless of database activity, Adaptive Checkpointing allowed the engine to dynamically adjust checkpoint frequency based on the database workload. This resulted in reduced response times during heavy loads and increased recovery time efficiency.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
