|Subject||RE: [firebird-support] Slow Sweep speed on large database - Long post|
> -----Original Message-----<snip>
> From: firstname.lastname@example.org
> [mailto:email@example.com] On Behalf Of
> Eduardo A. Salgado
> Sent: Thursday, August 04, 2005 2:11 PM
> To: firstname.lastname@example.org
> Subject: [firebird-support] Slow Sweep speed on large
> database - Long post
> Longish question that deals with speed, of course.
> Now doing a back up and restore takes too long. We do thisTurn off garbage collection when backing up (-G), there should be no
> overnight and it is time for the users to need access to the
> database and backup alone has not finished.
problem backing up and restoring a 4gig database file.. I just backed
up a 9gig database in 22 minutes, dual opteron 242's, 2gig ram, 7200rpm
SATA drives.. Restore shouldn't take too much longer unless there are a
ton of indexes to rebuild, and of course other factors..hd speed..