Subject RE: [firebird-support] Is it better to have FireBird on its own Hard Disk?
Author Alan McDonald
> Hi All
>
> Did somebody maybe do any tests on a computer where the Operating
> System is say on C:\ and FireBird is on another hard disk to see if
> there is an improvement for the database responsiveness and the
> FireBird app.
>
> I assume due to multi-tasking and the fact that the same (only one)
> hard disk is shared by many apps, that while the FireBird service is
> reading data that it may be interrupted to read other data required by
> another app (or the O/S), or are all records read and retrurned as
> an "atomic" operattion.
>
> What other steps can be taken to make the database access faster. I
> assume that the highest RPM and largest Hard Disk buffer will also help.
>
> What O/S is best for FireBird, and is there a significant speed-
> increese between 2000 -> XP -> 2003, or is the O/S minimal?
>
> Thanks
> Anton

I haven't done any tests but I have a variety of setups mentioned here and
there is no difference between them that I can detect.
I have found that Win2000 is slow for PHP, 2003 is much better (almost as
good as linux).
But my comment would be that you will get far better performance
differential if you concentrate on other things than which disk and which
OS.
You code, your connectivity layer, your application design, etc speak far
more about your performance.
Alan