|
|
Posted by David Haynes on 02/06/06 15:40
E.T. Grey wrote:
>
>
> NC wrote:
>> E.T. Grey wrote:
>>
>>>>> I have a (LARGE) set of historical data that I want to keep
>>>>> on a central server, as several separate files.
>>>>
>>>>
>>>> How large exactly?
>>>
>>> At last count, there are about 65,000 distinct files (and increasing)
>>
>> ...
>>
>>> Each file has the equivalent of approx 1M rows (yes - thats 1 million)
>>
>> ...
>>
>>> If you multiply the number of rows (on avg) by the number of files -
>>> you can quickly see why using a db as a repository would be a
>>> poor design choice.
>>
>>
>> Sorry, I can't. 65 million records is a manageable database.
>>
>>
>
> Its amazing how some people once having set their mind on one thing,
> wont change it - even when presented with the facts. Last time I
> checked, 65,000 x 1 million = 65 billion - not 65 million. Ah well - you
> can't win them all.
>
Well, my question is "Do all 65 billion records need to be active at all
times?" If not, doing some roll-up/archival strategy may reduce this to
a usable size.
-david-
Navigation:
[Reply to this message]
|