[firebird-support] Re: Is it possible to store firebird DB file on a NAS?
WD my Cloud it enables smb/cifs protocol so a network share can be mapped as drive In Firebird 2.5.x is possible with RemoteFileOpenAbility 1 in the firebird.conf (With a few big warnings if you read the conf file) you need to take care only the Firebird server to have access to that NAS share (exclusive access) I recommend an usb3.0/thunderbolt ssd drive for io speed If you follow this benchmark As you can see, performance with random IO operations shows ~8x better results for SSD drive. We knew from our experience with customers databases that SSD is 30-50% faster with real-word applications, but 8x increase is very high. http://ib-aid.com/en/articles/firebird-performance-degradation-tests-myths-and-truth/ http://ib-aid.com/en/articles/firebird-performance-degradation-tests-myths-and-truth/
[firebird-support] Re: Is it possible to store firebird DB file on a NAS?
Hi,Thanks for you reply. If I understand correctly, WD Cloud come with password to access private folder. So, I am planing to install FB server where NAS attached and set private folder in NAS, then map this folder as a network drive. Other users, don't have direct access to this private folder. Accessing FB database is just the same with format comp name:network drive on NAS With this setting, is this necessary to set RemoteFileOpenAbility = 1? WD Cloud come with pre-installed harddisk, so I can't replace its disk. I still have a doubt with this cloud, it got good reviewer by some webs, but got bad rating by users experiences. Regards, Anto