Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
June Tong — — source: Informix-list mailing list archive (1991-1998)
Malcolm Weallans (onlinedbc@cix.compulink.co.uk) wrote:
: By my calculation you would hit a long transaction if the query took
: longer than 2.5 minutes. I would certainly suggest that you should have
: bigger logs. If they fill that fast you are probably spending a great
: percentage of your time handling log changeover. After all, doesn't
: OnLine always do a checkpoint when it changes logs?
No. OnLine forces a checkpoint when it changes logs and the next log contains
the last checkpoint. In other words, if you have 10 logs, and no checkpoint
occurs for any other reason, you will checkpoint in the 9th log after the last
checkpoint.
June
---- June Tong Informix Software ----
---- Senior Consultant (415) 926-6140 ----
---- International Support junet@informix.com ----
< Location omitted... I hope you're enjoying this, Billy >
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.