Re: Problem with Temp Tables and Logging

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 >