Re: How fast is fast recovery on V5

Subject: How fast is fast recovery on V5 From: John Clutterbuck <jclutterbuck@sbs.siemens.co.uk> Date: Fri, 11 Apr 1997 23:38:52 +0100 Message-ID: <334EBD7C.75ED@sbs.siemens.co.uk> >Hi > >We have been waiting 7 hours for a recovery to complete from what looks >like 3.75 log files on Informix V5.3 with 2k page size. > >There had been some substantial deletes etc. just before it went down. > >Is this to be expected - shall we cut our losses and go back to a recent >level 0. > >Thanks in anticipation The amount of time that it takes to recover the logs is dependent on what is being recovered. In 5.x, the recovery is single threaded. That means that if the work was the work of 5 threads that were working a solid hour each, then the recovery would take roughly 5 hours. 3.75 log files may not be very long, but it could be quite long. How large is each log file? Were indexes being built during the span of the logs? All of these are factors in determining the amount of time of the recovery. If indexes were being built, that would be a rather small log entry, but would take quite a bit of time to actually complete. Madison Pruet