Re: A Big Ol' Database
> Can somebody tell me the results of this, as far as resource usage, memory
> requirements, etc.:
>
> -- start proggie
> sequence picks
> picks = repeat( {0,0,0,0,0,0}, 25827165 )
> -- write this to an EDS database
> -- end proggie
>
> Thanks!
> ck
>
> P.S. The number 25,827,165 is the number of combinations available when
> picking six numbers from 54, which is the Texas Lottery's system.
I think each atom will take up 32 bits (for non floating points)
32*6=192bits per item
192*25827165=4958815680 (bits required in total for the data)
now, there will need to be a pointer to each sequence so add another
25827165*32 (826469280)
4958815680+826469280=6611754240
There must be other overheads, but I don't know what they are.
Anyway, that converted to bytes is 826,469,280 bytes.
That's quite a lot of disk swapping :) Wouldn't it be better to calculate the
values in
real time as they are needed?
All the above is based on half remembered things that rob and other
people have mentioned about the internal workings of Euphoria, it
could very easily be totally wrong :)
Thomas Parslow (PatRat) ICQ #:26359483
Rat Software
http://www.rat-software.com/
Please leave quoted text in place when replying
|
Not Categorized, Please Help
|
|
