You could use
DECIMAL(17,15) - but it will take you 17+2bytes per record...
but you could split the number in 2 parts
before the DOT . because you have 2 number use TINYINT - takes 1 byte
BIGINT - takes 8 bytes
So
you have a total of 9 bytes
DOUBLE - and it will take you 8 bytes per record
So DOUBLE it's a good choice...
Of course depending on what you do with the numbers the separation could
provve better even if you loose one byte pe record !
Gabriel PREDA
----- Original Message -----
From: "Galen" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Wednesday, February 02, 2005 9:15 AM
Subject: Best way to store numeric data?
> I've got a huge table going, and it's storing a load of numeric data.
> Basically, a percentage or single digit rank, one or two digits before
> the decimal and fifteen after, like this:
>
> 6.984789027653891
> 39.484789039053891
>
> What is the most efficient way to store these values? I will be
> frequently sorting results by them or using math with them, so speed is
> important, but I also don't want to be wasteful of disk space as I
> currently have over three quarters of a million records, with more to
> come.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
