Hi I am interested to hear what your experience is about putting the the <database>.log file on another disk (controller) as is good practice? I am also wondering what it means for compatibility when transferring the (two) database files between Windows and macOS. As the path to the <database>.log file is somewhere stored in the <database>.db file (I assume), is it stored in Windows and Unix/macOS form and therefor still the same convenience as if they are both at the same location. By the way, I like to say that for our company, this feature of being able to transfer the database files between various operating systems is just outstanding! One big practical advantage compared to other databases. Regards, Robert |
It depends how often the data is modified in the DB. If your log file doesn't grow fast, maybe it is not worth separating DB and LOG files. I/O analysis is important. This isn't the actual answer, just a comment, but I'd better test different scenarios on your environment before suggesting to separate the files.
If you have the same question regarding the TEMP file, please read this thread: http://sqlanywhere-forum.sap.com/questions/28934/move-tempdb-to-ram-any-theoretical-improvements You see, even the ram disk is not worth using it :(