RE: Differences in handling logging (between DB's)

Couldn't send this to your private e-mail address (no-spam) How about Progress, do you know anything about progress ? (Sorry, still gathering amunition for the collegue that loves Progress and hates Informix) -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Tim Schaefer Sent: Wednesday, February 11, 2004 7:49 AM To: informix-list@iiug.org Subject: Re: Differences in handling logging (between DB's) Andrew, Just some trivia, not arguing for or against your points. The ability to control logging is what makes IDS the most totally controlable database on the planet. None of the other databases worth mentioning, except maybe possibly Oracle has the flexibility when it comes to transaction logs. I'm not discounting or dismissing your points, but maybe only pointing out please appreciate the difference IDS brought to the table, for me at least, it's now all academic. The idea, the luxury of arguing the ability to log or not to log, it makes me cry. :-( SQL-Server/Sybase - absolutely no control over logging or size of logs. Everything is logged, no control over size of logs or how many, but you can specify what the size of "the" log should start out at. Inside "the log" file, SQL-Server determines how many logs, when checkpoints occur, how big it gets, etc. Pretty pathetic, totally automatic. DB2 - some ability but not really a planned or thought out ability. Almost no docs on logging at all. Last I checked it's always on. MySQL - Either you use MyISAM with limited low-level "non-logged" logging or InnoDB always-logged. No "dbspaces". MyISAM still has a 4GB limit on tables on Linux. Informix - logged, non-logged, number of logs, size of logs. ondblog, onlog, etc. Totally flexible, checkpoint management, really great monitoring, onstats. Unmatched for DBA control. Lousy backup/restore options. Oracle - has the infamous redo logs, which puts it pretty much Informix's only equal as even coming remotely close to the flexibility of Informix. ________________________________ << ella for Spam Control >> has removed 1296 Spam messages and set aside 240 Newsletters for me You can use it too - and it's FREE! www.ellaforspam.com sending to informix-list sending to informix-list