Subject Re: [ib-support] Firebird and Network Attached Storage?
Author John Bellardo
David,

On Tuesday, January 15, 2002, at 09:57 AM, David Montgomery wrote:

> Hi,
>
> [...]
> Does anyone care to comment on this potential network design? I'm a bit
> leary of sucking all that data through even a large ethernet pipe. Will
> having the disks in a different box really kill performance?

To answer your question, it depends on the activity level of your
database. Do you have any numbers that tell you how much data you are
currently pushing through your existing SCSI controller? Are you
planning on using forces writes? If not there is a higher change of
database corruption when one of the servers crashes.

The other problem is FB/IB does a check to see if the database file is
on a network drive, and if it is it won't allow you to open it. This
protects the database from corruption, because if different servers on
different machines open the same database file at the same time it will
get corrupted. If you really want to do this (maybe just for testing
purposes) I can tell you what you need to change in the source to
disable the check. But disabling it will give you more than enough rope
to hang yourself.

-John