On Tue, Nov 01, 2005 at 11:16:58PM +0100, Martijn van Oosterhout wrote: > Consider the algorithm: A number is stored as base + exponent. To > multiply two numbers you can multiply the bases and add the exponents. > OTOH, if you store the decimal inside the data, now you have to extract > it again before you can do any calculating. So you've traded CPU time > for disk space. Is diskspace cheaper or more expensive than CPU? > Debatable I guess.
Well, I/O bandwidth is much more expensive than either CPU or disk space... -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
