* 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 data
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,
Please don't hijack threads.
In the last episode (Jan 30), Jonas Ask?s said:
> I'm wondering how well MySQL compress data. I'm about to design a
> database which will hold mainly _a lot_ of FLOAT-values, and since I do
> not really know how well MySQL compress data or how I could calculate
> this
.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.932.0211
c. 601.209.4985
-Original Message-
From: Jonas Askås [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 30, 2003 2:52 AM
To: [EMAIL PROTECTED]
Subject: Storage issue
Hi,
I'm wondering how well MySQL compress
> I'm wondering how well MySQL compress data. I'm about to design a
> database which will hold mainly _a lot_ of FLOAT-values, and since I do
> not really know how well MySQL compress data or how I could calculate
> this I'd really appriciate a little guidance.
see chapter 6.2.6 of the mysql manu
>Here's an example of how much data could be stored in a year:
>1 value/minute are stored = 1440 values/day.
>365 days / year.
>We have 100 different tables with 25 columns each.
>This makes 100*25*365*1440 = 1 314 000 000 values per year.
>A typical value could be 25,5624.
>How much space (in
* Jonas Askås
> I'm wondering how well MySQL compress data. I'm about to design a
> database which will hold mainly _a lot_ of FLOAT-values, and since I do
> not really know how well MySQL compress data or how I could calculate
> this I'd really appriciate a little guidance.
mysql does not compres
Hi,
I'm wondering how well MySQL compress data. I'm about to design a
database which will hold mainly _a lot_ of FLOAT-values, and since I do
not really know how well MySQL compress data or how I could calculate
this I'd really appriciate a little guidance.
Here's an example of how much data coul
Hi,
I'm wondering how well MySQL compress data. I'm about to design a
database which will hold mainly _a lot_ of FLOAT-values, and since I do
not really know how well MySQL compress data or how I could calculate
this I'd really appriciate a little guidance.
Here's an example of how much data coul
Hi,
I'm wondering how well MySQL compress data. I'm about to design a
database which will hold mainly _a lot_ of FLOAT-values, and since I do
not really know how well MySQL compress data or how I could calculate
this I'd really appriciate a little guidance.
Here's an example of how much data coul
10 matches
Mail list logo
