From: Ann W. H. <aha...@ib...> - 2001-06-20 01:38:17
|
At 11:15 PM 6/19/2001 +0200, Mike Nordell wrote: > > I would also suggest that database files be open with > > FILE_FLAG_WRITE_THROUGH by default, especially for Windows. > >I wouldn't. It would _kill_ performance. What I think (again without >thinking it throught too much) is buffer flush on transaction commit. That's >it. Unfortunately, the consistency of the database on-disk depends on careful write - writing pages in a specific order. Flush on commit, though adequate if successful, leads to corrupt intermediate states. Regards, Ann www.ibphoenix.com We have answers. |