3 ms·
Typically when you COMMIT the changes will be written to the transaction log, which is sequential, then later written asynchronously to the data files. So you g
by gaius 12y ago
Typically when you COMMIT the changes will be written to the transaction log, which is sequential, then later written asynchronously to the data files. So you get the performance of sequential writes and the flexibility of random writes, which is nice. But once something is COMMIT'd it is permanent, it will survive any crash after COMMIT returns. If it has not yet be written to the datafiles, the recovery process will do that.