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

    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