Re: End of hypocrisy ?
On 8/8/2014 4:16 PM, Joe wrote:
> On Fri, 08 Aug 2014 13:38:55 -0400
> Jerry Stuckle <jstuckle@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
Reply to: