On 30 Jan 2003, at 15:41, Roger Baklund wrote:
> However, you would normally need to store something more than just the
> float value, otherwise it would be difficult to use the data for
> anything... assuming you also need an integer pointer for each value,
> you would need 4 extra bytes per row, and mysql also occupies 1 byte
> for a deletion flag, which will give you a total record length of
> 4+4+1=9 or 8+4+1=13.
>
> 1314000000 * 9 = 11278 Mb
> 1314000000 * 13 = 16290 Mb
Jonas said the tables had 25 floats in each record, so the added
integer ID and deletion flag would only occur 1/25 as often. There
are 1,314,000,000 values but only 52,560,000 records, and the record
size would be 25*4+4+1=105 or 25*8+4+1=205. The total size would
then be
52560000 * 105 = 5519 MB
52560000 * 205 = 10775 MB
(using ISO megabytes, 10**6, as opposed to mebibytes, 2**20).
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
Phone 202-667-6653
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
