Re: Transaction Log

Mark Mielke <mark@xxxxxxxxxxxxxx> · Wed, 29 Aug 2007 15:54:05 -0400

mbguy2000-1@xxxxxxxxx wrote:

  For best performance, the transaction log should be on a
separate disk.

Does
the writing of the log benefit from a battery backed controller as
well?  If not, what do people think about writing the transaction log
to a flash card or the like?

How popular are the battery backed RAM drives that exist today? I don't
recall seeing them spoken about in this mailing list. The local geek
shop has these devices on sale. Are they still too expensive?

For those that don't know what I am talking about - they are PCI
devices that present themselves as a hard drive, but are filled with
commodity RAM instead of a magnetic platter, and a battery that lasts a
few weeks without external power.

Cheers,

mark

-- 
Mark Mielke <mark@xxxxxxxxx>