On Fri, 08 Aug 2014 13:38:55 -0400 Jerry Stuckle <jstuc...@attglobal.net> wrote:
> > Nope. First of all, messages are NOT relational, unless you are > calling the source of the message and the text of the message > relational. > > Second, there is significant additional overhead when inserting into a > SQL database vs. adding to the end of a text file. > > Third, to insert or retrieve data from the SQL database, you need the > SQL engine running. What if there is a problem with the engine? > With a text file, all you need is the file system up to add to the > file, and a command line prompt plus grep, head, tail, etc. to search > the file (vim is also a possibility but not necessary). It is also > faster to grep a text file than a SQL database unless the log file is > huge. > > Fourth, the same data in a SQL file takes up more space than in a > text file. > > Fifth, log files can easily be rotated in a text file; it is much > harder with a SQL database. > > I just can't see any advantages to using a SQL database over text > files > Sixth, Microsoft does it... -- Joe -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org Archive: https://lists.debian.org/20140808211607.54527...@jresid.jretrading.com