Re: database sizes. was Does a blank field take up disk space?

On 7/31/2016 11:26 PM, John Levine wrote:
>>> I use a mysql database on my 1U server to track the incoming mail and
>>> what I did with it. The table of incoming SMTP connections has 276
>>> million rows, and the table of recipient addresses has 416 million
>>> rows, each partitioned into three pieces.
>>>
>>> The table listing the spam complaints has 23 million rows, and of the
>>> recipients of the spam has 37 million rows.
>>>
>>> It's using stock mysql from the FreeBSD ports. The performance is adequate
>>> for what I'm doing, and it has no problem keeping up with all the incoming
>>> mail and logging it in real time.
>>
>> And if you ever had to do anything serious with it, you'd find
>> performance is terrible. But obviously all you're doing is using it for
>> logging - which is low overhead.
>>
>> You might as well just use a flat file.

> 
> Once again, it is not a very good idea to make assertions about
> databases you know nothing about.  No, I don't just use it for
> logging.
> 

From what you said, that's all you're using it for. If your statement is incorrect, then that's your problem, not mine.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
jstucklex_at_attglobal.net
==================