I will never be bored
-
Xiangyang Liu ??? wrote:
I suspect it is not the largest table
When I think of that I think of this: You are standing in front of a big darkgrey stonewall with a black iron door in it. The sky is dark and cloudy and it is quiet around you but you have a bad feeling here. What do you want to do now?
cheers, Chris Maunder
CodeProject.com : C++ MVP
A Big Green Snake Bars The Way!
Software Zen:
delete this;
Fold With Us![^] -
Xiangyang Liu ??? wrote:
I suspect it is not the largest table
When I think of that I think of this: You are standing in front of a big darkgrey stonewall with a black iron door in it. The sky is dark and cloudy and it is quiet around you but you have a bad feeling here. What do you want to do now?
cheers, Chris Maunder
CodeProject.com : C++ MVP
Just found another table with 161 fields.
My .NET Business Application Framework My Home Page My Younger Son & His "PET"
-
I'm guessing that the original developer had never even heard of normalisation.
Deja View - the feeling that you've seen this post before.
Maybe he was forced by the CEO to keep it 'simple' so that the CEO can understand all the code. I have had a team lead telling me I must simple code, so he could understand what it does. I wonder what I was suppose to do there...
xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008) -
I'm guessing that the original developer had never even heard of normalisation.
Deja View - the feeling that you've seen this post before.
Exactly what I thought.
Don't forget to vote if the response was helpful
Sig history "dad" Ishmail-Samuel Mustafa "There's no point questioning the actions of a c0ck-juggling thunderc*nt" From the book of testy commentary by martin_hughes Unix is a Four Letter Word, and Vi is a Two Letter Abbreviation
-
I'm guessing that the original developer had never even heard of normalisation.
Deja View - the feeling that you've seen this post before.
Pete O'Hanlon wrote:
I'm guessing that the original developer had never even heard of normalisation.
Normalization? What a strange word. :-D
My .NET Business Application Framework My Home Page My Younger Son & His "PET"
-
Xiangyang Liu ??? wrote:
a database table that has 119 fields
What, may I ask is it a table of? I once made a database for Whitbread of EVERYTHING they bought an sold, Beer, Food, Snack, Furniture, pet food, cleaning etc It had over 20,000 records and went to 45 fields, I thought that was a biggun!
------------------------------------ Hungrþverrir lét herjat hríðar gagls á Skíði (the hunger battle-birds were filled in Skye with blood of foemen killed)
Pah! I say. We have a table with over 100 columns, a clone of a customers database has over 400k rows. Works like a charm.
I'm largely language agnostic
After a while they all bug me :doh:
-
I'm guessing that the original developer had never even heard of normalisation.
Deja View - the feeling that you've seen this post before.
We have a few very large tables that really can't be normalized any further. There's just an inordinate number of datapoints that need to be collected for an entity. Any division is arbitrary, although on the really big ones they were split between a common table and an extened details table.
I'm largely language agnostic
After a while they all bug me :doh:
-
Xiangyang Liu ??? wrote:
I suspect it is not the largest table
When I think of that I think of this: You are standing in front of a big darkgrey stonewall with a black iron door in it. The sky is dark and cloudy and it is quiet around you but you have a bad feeling here. What do you want to do now?
cheers, Chris Maunder
CodeProject.com : C++ MVP
Grab a stiff drink... software development is enough to drive you to drink sometimes, if only it was allowed at work, then I'd have to use public transport, which in itself is frustrating enough to drive you to drink, it's a vicious cycle... :-D
He who makes a beast out of himself gets rid of the pain of being a man
-
Grab a stiff drink... software development is enough to drive you to drink sometimes, if only it was allowed at work, then I'd have to use public transport, which in itself is frustrating enough to drive you to drink, it's a vicious cycle... :-D
He who makes a beast out of himself gets rid of the pain of being a man
Phannon wrote:
software development is enough to drive you to drink sometimes
Be careful when working with abstract classes: Don't drink and derive! :)
My .NET Business Application Framework My Home Page My Younger Son & His "PET"
-
Phannon wrote:
software development is enough to drive you to drink sometimes
Be careful when working with abstract classes: Don't drink and derive! :)
My .NET Business Application Framework My Home Page My Younger Son & His "PET"
-
... with a database table that has 119 fields. Exausted maybe, but not bored. I posted several months ago that the boss wanted me to work on a java project with 6000+ classes in 1500+ files. One of the database tables in this project has 119 fields, I suspect it is not the largest table.
My .NET Business Application Framework My Home Page My Younger Son & His "PET"
With code I work on I have a nearly photographic contextual memory. Whenever I am exposed to a massive Charlie Foxtrot years latter it will come back on me like a bad trip of acid. The worst part, will of course be that it only came back because I now have a simple elegant solution that I of course must take to my grave because no one cares. I feel sorry that you have to deal with it but at least its in Java :) I think some users of the forum drink to dull the pain.
Need software developed? Offering C# development all over the United States, ERL GLOBAL, Inc is the only call you will have to make.
Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway
Most of this sig is for Google, not ego. -
Grab a stiff drink... software development is enough to drive you to drink sometimes, if only it was allowed at work, then I'd have to use public transport, which in itself is frustrating enough to drive you to drink, it's a vicious cycle... :-D
He who makes a beast out of himself gets rid of the pain of being a man
-
... with a database table that has 119 fields. Exausted maybe, but not bored. I posted several months ago that the boss wanted me to work on a java project with 6000+ classes in 1500+ files. One of the database tables in this project has 119 fields, I suspect it is not the largest table.
My .NET Business Application Framework My Home Page My Younger Son & His "PET"
Sounds like Oracle Apps. God those people love UserDefined1, etc., Reference1, etc. :(
Cheetah. Ferret. Gonads. What more can I say? - Pete O'Hanlon
-
... with a database table that has 119 fields. Exausted maybe, but not bored. I posted several months ago that the boss wanted me to work on a java project with 6000+ classes in 1500+ files. One of the database tables in this project has 119 fields, I suspect it is not the largest table.
My .NET Business Application Framework My Home Page My Younger Son & His "PET"
Xiangyang Liu ??? wrote:
table that has 119 fields
That's impressive! A few years ago we hired a GPS/GIS company to map our power system and, knowing nothing of the subject, accepted their schema for the device data tables. Now I have a huge .mdb database with tables 70+ fields wide, most of which are empty. I wish there was a tool I could run on it to condense the tables down to only the essential fields, but I haven't located one yet.
"A Journey of a Thousand Rest Stops Begins with a Single Movement"
-
... with a database table that has 119 fields. Exausted maybe, but not bored. I posted several months ago that the boss wanted me to work on a java project with 6000+ classes in 1500+ files. One of the database tables in this project has 119 fields, I suspect it is not the largest table.
My .NET Business Application Framework My Home Page My Younger Son & His "PET"
119 fields? That's nothing! ;P I regularly get to work with an accounting package from Norway which has eight tables with more than 200 fields each, eleven tables with between 100 and 200 fields, and 202 other tables. The winner is a table called
OrdDocLn, with 312 fields. All with wonderful names likeM38,R9,MntTm,NWgtU, andTspAgrNo! :wtf:
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
