Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Other Discussions
  3. The Weird and The Wonderful
  4. 4096 Columns should be enough for anyone.

4096 Columns should be enough for anyone.

Scheduled Pinned Locked Moved The Weird and The Wonderful
csharpasp-netdatabaseoraclecom
22 Posts 15 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • B Brady Kelly

    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[^].

    Unscrambling Eggs: Decompiling ASP.NET

    L Offline
    L Offline
    Lost User
    wrote on last edited by
    #5

    In my system, each participant is a row, and each response is a column. I think he confuses relational databases with excel sheets :omg:

    B 1 Reply Last reply
    0
    • L Lost User

      In my system, each participant is a row, and each response is a column. I think he confuses relational databases with excel sheets :omg:

      B Offline
      B Offline
      Brady Kelly
      wrote on last edited by
      #6

      What's the difference? ;P

      Elusive problem with IIS7 static content.

      J 1 Reply Last reply
      0
      • B Brady Kelly

        What's the difference? ;P

        Elusive problem with IIS7 static content.

        J Offline
        J Offline
        Jeslan
        wrote on last edited by
        #7

        Excel spreadsheets are prettier. Eventually, they'll upgrade their Oracle database to Excel.

        M 1 Reply Last reply
        0
        • B Brady Kelly

          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[^].

          Unscrambling Eggs: Decompiling ASP.NET

          N Offline
          N Offline
          neilmajithia
          wrote on last edited by
          #8

          was the title of this supposed to be a play on the old bgates joke of only ever needing 640k

          B 1 Reply Last reply
          0
          • N neilmajithia

            was the title of this supposed to be a play on the old bgates joke of only ever needing 640k

            B Offline
            B Offline
            Brady Kelly
            wrote on last edited by
            #9

            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. :)

            Elusive problem with IIS7 static content.

            N 1 Reply Last reply
            0
            • B Brady Kelly

              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. :)

              Elusive problem with IIS7 static content.

              N Offline
              N Offline
              neilmajithia
              wrote on last edited by
              #10

              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.

              B 1 Reply Last reply
              0
              • N neilmajithia

                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.

                B Offline
                B Offline
                Brady Kelly
                wrote on last edited by
                #11

                I felt dirty hitting Access's 255 column limit. X|

                Elusive problem with IIS7 static content.

                R 1 Reply Last reply
                0
                • B Brady Kelly

                  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[^].

                  Unscrambling Eggs: Decompiling ASP.NET

                  G Offline
                  G Offline
                  Guffa
                  wrote on last edited by
                  #12

                  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.

                  1 Reply Last reply
                  0
                  • J Jeslan

                    Excel spreadsheets are prettier. Eventually, they'll upgrade their Oracle database to Excel.

                    M Offline
                    M Offline
                    Muhammad Asad Siddiqi
                    wrote on last edited by
                    #13

                    hahaha !! Good 1 . My comment makes no sense but I just couldnt stop laughing lmao :laugh:

                    1 Reply Last reply
                    0
                    • P Paul Conrad

                      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

                      S Offline
                      S Offline
                      Simon P Stevens
                      wrote on last edited by
                      #14

                      Any database table with a 1,000 columns should be flagged for restructuring deletion. ;)

                      Simon

                      P 1 Reply Last reply
                      0
                      • B Brady Kelly

                        I felt dirty hitting Access's 255 column limit. X|

                        Elusive problem with IIS7 static content.

                        R Offline
                        R Offline
                        rastaVnuce
                        wrote on last edited by
                        #15

                        (again on the Gates thing...) Well, 255 columns should be enough for anyone!

                        To hell with circumstances; I create opportunities.

                        1 Reply Last reply
                        0
                        • S Simon P Stevens

                          Any database table with a 1,000 columns should be flagged for restructuring deletion. ;)

                          Simon

                          P Offline
                          P Offline
                          Paul Conrad
                          wrote on last edited by
                          #16

                          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

                          1 Reply Last reply
                          0
                          • B Brady Kelly

                            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[^].

                            Unscrambling Eggs: Decompiling ASP.NET

                            N Offline
                            N Offline
                            Natza Mitzi
                            wrote on last edited by
                            #17

                            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

                            1 Reply Last reply
                            0
                            • B Brady Kelly

                              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[^].

                              Unscrambling Eggs: Decompiling ASP.NET

                              K Offline
                              K Offline
                              KarstenK
                              wrote on last edited by
                              #18

                              Are you sure that the database isnt confusing about rows and columns? Are the needed? Who has to deal with such a lot of columns? :confused::confused::confused:

                              Greetings from Germany

                              1 Reply Last reply
                              0
                              • B Brady Kelly

                                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[^].

                                Unscrambling Eggs: Decompiling ASP.NET

                                K Offline
                                K Offline
                                KarstenK
                                wrote on last edited by
                                #19

                                I am curious about what you will save in 1000 columns? :confused::~

                                Greetings from Germany

                                N 1 Reply Last reply
                                0
                                • K KarstenK

                                  I am curious about what you will save in 1000 columns? :confused::~

                                  Greetings from Germany

                                  N Offline
                                  N Offline
                                  Natza Mitzi
                                  wrote on last edited by
                                  #20

                                  Datamining apps require many precomputed columns one can easily reach more than 1000 columns

                                  Natza Mitzi

                                  1 Reply Last reply
                                  0
                                  • B Brady Kelly

                                    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[^].

                                    Unscrambling Eggs: Decompiling ASP.NET

                                    T Offline
                                    T Offline
                                    ToddHileHoffer
                                    wrote on last edited by
                                    #21

                                    I think the original poster was goofing. What possible entity could have 4000 attributes?

                                    I didn't get any requirements for the signature

                                    1 Reply Last reply
                                    0
                                    • B Brady Kelly

                                      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[^].

                                      Unscrambling Eggs: Decompiling ASP.NET

                                      C Offline
                                      C Offline
                                      Cristian Amarie
                                      wrote on last edited by
                                      #22

                                      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

                                      1 Reply Last reply
                                      0
                                      Reply
                                      • Reply as topic
                                      Log in to reply
                                      • Oldest to Newest
                                      • Newest to Oldest
                                      • Most Votes


                                      • Login

                                      • Don't have an account? Register

                                      • Login or register to search.
                                      • First post
                                        Last post
                                      0
                                      • Categories
                                      • Recent
                                      • Tags
                                      • Popular
                                      • World
                                      • Users
                                      • Groups