How to Handle Dirty Instance
CUBRID flushes dirty data (or dirty instances) in the client buffers to the database (server) such as the following situations. In additions to those, there can be more situations where flushes can be performed.
- Dirty data can be flushed to server when a transaction is committed.
- Some of dirty data can be flushed to server when a lot of data is loaded into the client buffers.
- Dirty data of table A can be flushed to server when the schema of table A is updated.
- Dirty data of table A can be flushed to server when the table A is retrieved (SELECT)
- Some of dirty data can be flushed to server when a server function is called.