4096 Columns should be enough for anyone.
-
darkelv wrote:
the database of 991 tables that I am looking at....
Wow, there is also a summary table, I suppose. :-D
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[My articles] -
I'm constantly having to compromise with the physical limitations of my database, such as having to pick and choose which attributes to delete, as the tables in my Oracle database reached it's 1000 column limit a long time ago. While these limits have forced me clean up the data and consolidate, it's a major annoyance that I shouldn't have to deal with[^].
-
In my system, each participant is a row, and each response is a column. I think he confuses relational databases with excel sheets :omg:
What's the difference? ;P
-
What's the difference? ;P
-
I'm constantly having to compromise with the physical limitations of my database, such as having to pick and choose which attributes to delete, as the tables in my Oracle database reached it's 1000 column limit a long time ago. While these limits have forced me clean up the data and consolidate, it's a major annoyance that I shouldn't have to deal with[^].
was the title of this supposed to be a play on the old bgates joke of only ever needing 640k
-
was the title of this supposed to be a play on the old bgates joke of only ever needing 640k
neilmajithia wrote:
was the title of this supposed to be a play on the old bgates joke of only ever needing 640
No, the title was a play on the Gates thing. :)
-
neilmajithia wrote:
was the title of this supposed to be a play on the old bgates joke of only ever needing 640
No, the title was a play on the Gates thing. :)
if i ever come across a table with sover 4000 columns id pack my desk, leave by the nearest fire exit and email in my resigation when i got home.
-
if i ever come across a table with sover 4000 columns id pack my desk, leave by the nearest fire exit and email in my resigation when i got home.
I felt dirty hitting Access's 255 column limit. X|
-
I'm constantly having to compromise with the physical limitations of my database, such as having to pick and choose which attributes to delete, as the tables in my Oracle database reached it's 1000 column limit a long time ago. While these limits have forced me clean up the data and consolidate, it's a major annoyance that I shouldn't have to deal with[^].
TRCH (The Real Coding Horror) is in my opinion the database design. As comparison... For performance reasons we have a separate database intended for read-access, to which we copy the data in a less relational manner. The result is a few flat tables with a horrible number of columns. Still the worst one only has 160 columns...
Despite everything, the person most likely to be fooling you next is yourself.
-
Excel spreadsheets are prettier. Eventually, they'll upgrade their Oracle database to Excel.
hahaha !! Good 1 . My comment makes no sense but I just couldnt stop laughing lmao :laugh:
-
Any database table with a 1,000 columns should be flagged for restructuring. That is indeed a horror.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
Any database table with a 1,000 columns should be flagged for restructuring deletion. ;)
Simon
-
I felt dirty hitting Access's 255 column limit. X|
(again on the Gates thing...) Well, 255 columns should be enough for anyone!
To hell with circumstances; I create opportunities.
-
Any database table with a 1,000 columns should be flagged for restructuring deletion. ;)
Simon
Yes, and also terminate the database architect who came up with the idea.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
-
I'm constantly having to compromise with the physical limitations of my database, such as having to pick and choose which attributes to delete, as the tables in my Oracle database reached it's 1000 column limit a long time ago. While these limits have forced me clean up the data and consolidate, it's a major annoyance that I shouldn't have to deal with[^].
I am sorry to tell you that limitations like this exist in many places. For example you can not display this data since DataGrids have a limitation of 65000 pixel width. As you can see I marked this as news ;)
Natza Mitzi
-
I'm constantly having to compromise with the physical limitations of my database, such as having to pick and choose which attributes to delete, as the tables in my Oracle database reached it's 1000 column limit a long time ago. While these limits have forced me clean up the data and consolidate, it's a major annoyance that I shouldn't have to deal with[^].
-
I'm constantly having to compromise with the physical limitations of my database, such as having to pick and choose which attributes to delete, as the tables in my Oracle database reached it's 1000 column limit a long time ago. While these limits have forced me clean up the data and consolidate, it's a major annoyance that I shouldn't have to deal with[^].
-
I am curious about what you will save in 1000 columns? :confused::~
Greetings from Germany
Datamining apps require many precomputed columns one can easily reach more than 1000 columns
Natza Mitzi
-
I'm constantly having to compromise with the physical limitations of my database, such as having to pick and choose which attributes to delete, as the tables in my Oracle database reached it's 1000 column limit a long time ago. While these limits have forced me clean up the data and consolidate, it's a major annoyance that I shouldn't have to deal with[^].
I think the original poster was goofing. What possible entity could have 4000 attributes?
I didn't get any requirements for the signature
-
I'm constantly having to compromise with the physical limitations of my database, such as having to pick and choose which attributes to delete, as the tables in my Oracle database reached it's 1000 column limit a long time ago. While these limits have forced me clean up the data and consolidate, it's a major annoyance that I shouldn't have to deal with[^].
For 1000 columns, all can be done is to emit a fatwa for the db "architect". ("Tell me, people, am I going insane?" - Black Sabbath - Sabotage, 1975, "Am I going insane (Radio)").
Nuclear launch detected