When WRITETHROUGH is specified, the system does not buffer disk writes.
To specify this directive for an individual file, use $SET statements in your source so that the directive is in effect only
for the part of the source containing the file's SELECT statement.
Using WRITETHROUGH helps improve the integrity of data files by ensuring that every write operation goes to the disk file
straight away, reducing the possibility of losing data if your computer crashes. However, it also bypasses all cacheing and
blocking methods, resulting in poorer performance.
Comments:
When WRITETHROUGH is specified, the system does not buffer disk writes.
To specify this directive for an individual file, use $SET statements in your source so that the directive is in effect only for the part of the source containing the file's SELECT statement.
Using WRITETHROUGH helps improve the integrity of data files by ensuring that every write operation goes to the disk file straight away, reducing the possibility of losing data if your computer crashes. However, it also bypasses all cacheing and blocking methods, resulting in poorer performance.