| Re: Loop through array, change headings [message #184467 is a reply to message #184466] |
Thu, 02 January 2014 15:39   |
Beauregard T. Shagnas
Messages: 154
Registered: September 2010
Karma:
|
Senior Member |
|
|
Peter H. Coffin wrote:
> Denis McMahon wrote:
>> Norman Peelman wrote:
>>> The whole idea behind relational databases is to set things up so that
>>> you don't need to make changes like that.
>>
>> Norman, remember that richard is the guy that sets up a separate table
>> for each year's records because that's more sensible (in richard
>> land[1]) than having a year field in the record table.
>>
>> [1] Any semblance of richard land to cloud cuckoo land is probably not
>> coincidental.
>
> I think there was something about that helping to manage the size of the
> tables as well. Because any database will break if you put more than a
> couple thousand rows into a table...
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.
--
-bts
-This space for rent, but the price is high
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]