* Keith C. Ivey [...] > 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
You are probably right. I focused on the "1 value/minute are stored" part, and wondered why he would store a float for each field in a database... maybe average number of reads per field per second or similar... :) It is way more likely that your suggestion is correct. :) > 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). ISO? Is this new? I thought it "only" was an IEEE-supported IEC standard? <URL: http://physics.nist.gov/cuu/Units/binary.html > MB == 1024*1024, MiB == "Men in Black"... ;) -- Roger not much sql this time --------------------------------------------------------------------- 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
