Re: Loop through array, change headings [message #184529 is a reply to message #184468] |
Mon, 06 January 2014 00:23 |
Peter H. Coffin
Messages: 245 Registered: September 2010
Karma:
|
Senior Member |
|
|
On Thu, 02 Jan 2014 10:52:49 -0500, Jerry Stuckle wrote:
> On 1/2/2014 10:39 AM, Beauregard T. Shagnasty wrote:
>
>> Peter, please don't recommend the place you found that information as
>> any kind of reputable reference site. I've worked with databases that
>> had literally millions of records in single tables.
>>
>> If your "database" consists of an Excel spreadsheet, you may have a
>> minor point.
>
>
> I may be wrong - but I think he meant that was another richardism.
Indeed!
Most of the stuff I work with at $dayjob start off with 120 million
rows and we winnow it down to only the "most important" 7-8 million
records by sales records, maniacal guesswork, and willful violations
of normal form before loading it to the warehouse. One of the interim
tables usually pops a terarow by the 4th quarter run....
--
Better to teach a man to fish than to give him a fish. And if he can't
be bothered to learn to fish and starves to death, that's a good enough
outcome for me.
-- Steve VanDevender
|
|
|