Subject | Re: mass inserts |
---|---|
Author | sboyd_kanservu_ca |
Post date | 2002-04-09T16:19:16Z |
I only do this to populate virgin databases and then turn the forced
writes back on when the load is finished. If the system crashes
during the load, big deal, I just reload the database.
writes back on when the load is finished. If the system crashes
during the load, big deal, I just reload the database.
--- In ib-support@y..., Doug Chamberlin <DChamberlin@A...> wrote:
> At 04/09/2002 11:28 AM (Tuesday), 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.
>
> Hmmm.. So is turning them off, unless you just want a faster way of
> corrupting your database!
>
> In other words, I would leave forced writes on all the time (on a
Windows
> machine) no matter what.