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

    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