|
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 |
Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 17 Jan '18, 04:07
question was seen: 789 times
last updated: 17 Jan '18, 06:45
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 :(