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

>> 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. Received on Mon Aug 01 2016 - 05:26:03 CEST