What does the isc_tpb_no_auto_undo flag really do?
Does it mean that the database will not have a automatic rollback in case of
a problem?

Thanks

-----Original Message-----
From: Ann W. Harrison [mailto:aharrison@...]
Sent: Tuesday, April 09, 2002 8:59 AM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Re: mass inserts


At 03:28 PM 4/9/2002 +0000, sboyd_kanservu_ca wrote:

>Helen;
>
>Not that I doubt your expertise, becuase I don't, but turning forced
>writes on to improve performance is somewhat counter-intuitive.

Turning on forced writes forces the data to disk regularly. It is
possible to develop a huge backlog of unwritten data that makes
performance very erratic. I suspect that your problem is that
the server is consuming large amount of memory for an auto-undo
log. If you have control over your transactions, you should
use the isc_tpb_no_auto_undo tpb option.


Regards,

Ann
www.ibphoenix.com
We have answers.



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/