Physical Log and Logical Log

Posted in 1994

Manote Nuangchamnong - SCCS - 3737113 — 31 Aug 1994 11:08:46 GMT — source: Informix-list mailing list archive (1991-1998)

Hi Folks, I found some case at my friend's site. His Physical Log and Logical Log setting is : Physical Log size = 2000 Kbytes Logical Log size = 10000 Kbytes No. of Logical Log = 10 When he run daily 4GL-application with 70-80 users simultanously. The system speed went down lower than he expected to get. Do you think the size of Phy. Log and Logical Log can affect the system performance ? My Configuration is : Sparc 10 with SunOs 4.1.3 Informix online 5.0 Any comments or suggestion will be appreciated. Advanced Thanks, Manote N.