>>Which it does, if you don't let the OS decide when to write pages.

Ann,

how exactly do you control the OS deciedeing to write pages, say on win
2k server??

thanks

martin.




Check out www.ubique.webscape.co.nz <http://www.ubique.webscape.co.nz/>
Ubique --> "Drives Your Business"

W E B S C A P E
PO Box 22571
25 Carlyle Street
Christchurch
http://www.webscape.co.nz <http://www.webscape.co.nz/>

Phone 03 964 4020
Fax 03 365 9115
Email mc@... <mailto:tmc@...>

-----Original Message-----
From: Ann W. Harrison [mailto:aharrison@...]
Sent: Thursday, 1 April 2004 9:54 a.m.
To: firebird-support@yahoogroups.com
Subject: Re[2]: [firebird-support] power outages


Amy, et al.

Check the IBPhoenix site for "careful write". I've written a
fair amount
about the theory and practice behind InterBase/Firebird
recovery. By
design, InterBase and Firebird maintain the database
on-disk-structure in a
consistent state after every page write. As long as every page
is win the
order that the database requests and written completely, you'll
always have
a consistent database. In my twenty-odd years (some even more
odd than
others) in the relational database world, I've never seen a
partial page
write.

At Interbase Software Corp., we used the database for our code
management
system, e-mail, bug tracking, customer/prospect tracking,
financial
tracking, payroll, hr, everything. At one fairly early point in
the
development of InterBase, we were in some third-rate
semi-commercial
space. Power cords ran across the floor, normally duct-taped to
the
carpet, but at least once a week one of us would trip over
something and
cut power to a server. Add that to a power distribution system
that would
do credit to a third-world country, and you can imagine that we
had a great
deal of interest in seeing the database come back to life whole
and happy.

Which it does, if you don't let the OS decide when to write
pages.


Regards,


Ann




_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe

>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service <http://docs.yahoo.com/info/terms/> .



=========================================================
This e-mail has been scanned for Viruses and Content and cleared by NetIQ MailMarshal


[Non-text portions of this message have been removed]