[fulafel]

SQL commit is not allowed to finish before the data is safely on disk (that's the D in ACID).

[icebraining]

That's assuming that the RDBMS can tell. The disks may lie:|

[Filligree]

You should strive not to use such disks in your server. A machine reset won't power off the disks, though.

[fulafel]

Or the CPU or the memory or the OS...

[plorg]

Thus the 's' in reisub?

[kelnos]

The disk may lie. The 's' will get the OS to send everything out to the disk. Actually writing it to the platter (or flash part, or whatever) is at the disk's discretion.

[fulafel]

It's at the disk's discretion as far as the laws of physics are concerned, but this would a severely broken disk prone to losing data and if it was a major server disk vendor, the vendor would take a pretty serious hit to its reputation.

[dalore]

Yes, but my point was that I could send data to an ACID compliant server, and kill it before the commit happened and data will be lost. Just trying to point out to the parent poster that sending is not enough, you need to wait for the commiting.