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
- 73 Views
- IBM, I also Faced
- E-Mail Answers
Answer / 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 |
What is a light scan in informix?
why is update statistics important to a database?
List down the features of informix 4gl.
what is extent in informix?
who conceived and designed the informix database management system?
what is chunk in informix?
What is the role of binary large object in informix?
What is the use of extent in informix?
Explain about informix 4gl.
how would you convert a secondary server into a primary server ?
what are the informix isolation levels and can you explain each one ?
explain the purpose of optimizer directives and how/why you would use them
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
