Subject RE: [firebird-support] Server Defrag while Firebird database is active
Author Alan McDonald
> I am sure this has come up before but I could not find an answer.
> One of our customers wants to defrag the database server and I feel
> that our software should be fine with a defrag at any time. Of course,
> it would be best after hours for server performance reasons, IMO.
> I do have a slight concern about how our database server would react to
> a defrag. What is the effect, if any, of defragging the disk at a
> server while the Firebird database is active?
> -Eduardo

and apart from what Ann recommends, with fast HDs of today and NTFS, defrag
is nowhere near as effective as it was in the early days with slow HDs and
FAT systems.
It's effect is so marginal it's not really worth considering.