Miled Moukhtafi wrote:real OS (*NIX) do NOT have file extensions; so you must be referring to Windoze.
there is any difference in the speed IO if we create redo log file with extension .rdo or .log?!!!!
You can even make it *.txt , it would still remain Redo Log file.Yes. But Windows sometimes treats files differently when you call them different names. rename notepad.exe to notepad.txt and it won't start.
user11181920 wrote:Lot's of OS's aren't open source, but they don't behave in the bizarre fashion of Windows. "My momma always said Windows was like a box of chocolates ...."You can even make it *.txt , it would still remain Redo Log file.Yes. But Windows sometimes treats files differently when you call them different names. rename notepad.exe to notepad.txt and it won't start.
rename notepad.exe to setup.exe and it starts with Admin privileges(!).
May be Windows see that file is named .log, and turns on write-append mode when a program writes to this file, for better performance, so program does not need to call seek()? ;)
Who knows! Windows is not Open source.
jgarry wrote:I'm convinced that when it comes to ways in which your db can get corrupted, there's no such thing as an irrational fear. Just one more reason why I hate Windows. And why I don't think DBA's will become extinct within my grandson's lifetime.
I have this irrational fear that someone will associate the extension .log with a wordprocessing program that changes things silently, so someone opens on the log, goes "wtf?" closes it, and corrupts it. Even though I know that is much less likely than sysadmins removing old log files.
Probably from too many times seeing people copy things between unix and Windows, where some ways following the same directions convert CRLF and other ways don't.