> 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 manual.
> 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.
float: 4 byte, so you need about 5 gigs? But you will need space
for indexes and such as well. So just get an 18 Gig drive for the
start.
--
--------------------------------------------------------------------
[EMAIL PROTECTED] Collaborative Intrusion Detection
join http://www.dshield.org
---------------------------------------------------------------------
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
