On 8/8/2014 4:16 PM, Joe wrote: > 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... >
LOL! Jerry -- 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/53e5365e.3070...@attglobal.net
