Welcome to IWETHEY!
Post #190,426
1/16/05 8:11:15 PM
|
Give him the benefit
> Why was it spread over several tables? > Perhaps your issue was poor normalization > or schema design. Many shops tend to > create too many tables.
He was leading up to a critique of full normalization which in turn kill performance. Of course, "poor" normalization is a "poor" way of stating it, but it wasn't to the level of George.
|
Post #190,431
1/16/05 8:29:32 PM
|
Fairy nuff
I read his question as, "Why would you have informatoin about one person in multiple tables?" I assumed he's advocating a "theoretically correct" schema that wouldn't work in the real world. I concede the possibility he's describing a badly over-normalized schema, one of which I have seen in production and it blew chunks.
So tablizer, what were you getting at?
===
Purveyor of Doc Hope's [link|http://DocHope.com|fresh-baked dog biscuits and pet treats]. [link|http://DocHope.com|http://DocHope.com]
|
Post #190,457
1/17/05 1:57:15 AM
|
Barry's right; overnormalization is 1 of Bryce's hobbyhorses
|
Post #190,540
1/17/05 11:25:14 PM
|
Huh? What did I over-normalize?
________________ oop.ismad.com
|
Post #190,551
1/18/05 1:57:24 AM
|
It means the opposite of what you seem to think it does. HTH
|
Post #190,689
1/18/05 9:33:12 PM
|
Okay then, what did I UNDER-normalize?
Is this about that time that the info-world forums took a dump, I helped recreate the threads using a FoxPro script, and then we got into a big argument about storing lists of ID's in a cell instead of creating a many-to-many table? It was a one-shot script, not production ebay. So, lighten up.
________________ oop.ismad.com
|
Post #190,762
1/19/05 10:29:32 AM
|
SIGH... "A hobby-horse" means, something you like to...
...*go on and on about*, not something you like to *do*.
That's why "over-normalization" is "a hobby-horse" of yours -- because you *rant* about it all the time.
I was *not* saying that you like to *do* it.
Is comprehension *finally* starting to -- however slowly -- seep in?
Or shall we go over this for a few more rounds?
[link|mailto:MyUserId@MyISP.CountryCode|Christian R. Conrad] (I live in Finland, and my e-mail in-box is at the Saunalahti company.)
Your lies are of Microsoftian Scale and boring to boot. Your 'depression' may be the closest you ever come to recognizing truth: you have no 'inferiority complex', you are inferior - and something inside you recognizes this. - [link|http://z.iwethey.org/forums/render/content/show?contentid=71575|Ashton Brown]
|
Post #190,859
1/19/05 6:35:22 PM
|
Note: in this case it really is a bad idea
Our team inherited the database from another team. We created a view that joins the tables together into the view that we need, and querying that view has never come close to being a bottleneck, so we've never fixed it.
But we wouldn't have designed it that way in the first place, and if there were signs that this was becoming a bottleneck, then we'd fix it. (The application wouldn't need much fixing.)
Cheers, Ben
I have come to believe that idealism without discipline is a quick road to disaster, while discipline without idealism is pointless. -- Aaron Ward (my brother)
|
Concurrency: the race is on
- (
FuManChu)
- (40)
- Jan. 2, 2005, 10:37:48 AM EST
Interesting, but ...
- (
Another Scott)
- (4)
- Jan. 2, 2005, 11:12:25 AM EST
I think he's talking to shrinkwrappers
- (
FuManChu)
- Jan. 2, 2005, 09:06:36 PM EST
I'd criticize it differently
- (
ben_tilly)
- (2)
- Jan. 3, 2005, 02:16:22 AM EST
That's true for servers, less so for workstations
- (
drewk)
- (1)
- Jan. 3, 2005, 12:25:33 PM EST
True...
- (
ben_tilly)
- Jan. 5, 2005, 12:40:11 AM EST
Favorite quote
- (
drewk)
- (1)
- Jan. 3, 2005, 12:12:21 PM EST
Speaking of quotes... (new thread)
- (
folkert)
- Jan. 3, 2005, 12:52:47 PM EST
Just use databases and transactions. Fixed!
-NT
- (
tablizer)
- (32)
- Jan. 8, 2005, 05:59:50 PM EST
Yes and no...
- (
Simon_Jester)
- Jan. 8, 2005, 07:23:06 PM EST
And again, you demonstrate yourself to be wrong
- (
ben_tilly)
- (30)
- Jan. 10, 2005, 10:16:55 AM EST
Up with people
- (
FuManChu)
- (24)
- Jan. 10, 2005, 12:19:17 PM EST
No connection
- (
ben_tilly)
- (23)
- Jan. 10, 2005, 10:33:23 PM EST
Questions
- (
tablizer)
- (22)
- Jan. 15, 2005, 04:07:02 AM EST
Don't try to solve the problem
- (
ben_tilly)
- (7)
- Jan. 15, 2005, 09:12:24 AM EST
Dude, you are rude. Grow some people skills
- (
tablizer)
- (4)
- Jan. 16, 2005, 02:16:01 AM EST
This was one of your most hilarious posts ever, Bryce.
-NT
- (
CRConrad)
- (2)
- Jan. 17, 2005, 01:57:50 AM EST
I am learning NOT to flame back. Me grow up........I think
-NT
- (
tablizer)
- (1)
- Jan. 17, 2005, 10:59:48 PM EST
A: Doubt it. B: Still, YOU calling SOMEONE ELSE rude=>funnee
-NT
- (
CRConrad)
- Jan. 18, 2005, 02:00:54 AM EST
Yes, you did answer something
- (
ben_tilly)
- Jan. 19, 2005, 06:29:29 PM EST
lock and load
- (
cforde)
- (1)
- Jan. 17, 2005, 03:18:05 AM EST
re: lock and load
- (
tablizer)
- Jan. 17, 2005, 11:24:42 PM EST
Question for you
- (
drewk)
- (13)
- Jan. 16, 2005, 04:31:58 PM EST
All the damn time
- (
broomberg)
- (9)
- Jan. 16, 2005, 08:01:04 PM EST
No hints from the peanut gallery
- (
drewk)
- (8)
- Jan. 16, 2005, 08:05:00 PM EST
Give him the benefit
- (
broomberg)
- (7)
- Jan. 16, 2005, 08:11:15 PM EST
Fairy nuff
- (
drewk)
- (6)
- Jan. 16, 2005, 08:29:32 PM EST
Barry's right; overnormalization is 1 of Bryce's hobbyhorses
-NT
- (
CRConrad)
- (4)
- Jan. 17, 2005, 01:57:15 AM EST
Huh? What did I over-normalize?
-NT
- (
tablizer)
- (3)
- Jan. 17, 2005, 11:25:14 PM EST
It means the opposite of what you seem to think it does. HTH
-NT
- (
CRConrad)
- (2)
- Jan. 18, 2005, 01:57:24 AM EST
Okay then, what did I UNDER-normalize?
- (
tablizer)
- (1)
- Jan. 18, 2005, 09:33:12 PM EST
SIGH... "A hobby-horse" means, something you like to...
- (
CRConrad)
- Jan. 19, 2005, 10:29:32 AM EST
Note: in this case it really is a bad idea
- (
ben_tilly)
- Jan. 19, 2005, 06:35:22 PM EST
Re: Question for you
- (
tablizer)
- (2)
- Jan. 17, 2005, 11:17:29 PM EST
Also called trade-offs.
- (
static)
- (1)
- Jan. 18, 2005, 01:25:03 AM EST
re: Also called trade-offs
- (
tablizer)
- Jan. 18, 2005, 09:53:21 PM EST
Ah yes, the Upperson procedure
- (
tuberculosis)
- Jan. 10, 2005, 06:31:02 PM EST
Guilty until proven innocent?
-NT
- (
tablizer)
- (3)
- Jan. 15, 2005, 04:00:49 AM EST
No, you said something stupid
- (
ben_tilly)
- (2)
- Jan. 15, 2005, 09:16:55 AM EST
You don't seem to disagree anywhere
- (
tablizer)
- (1)
- Jan. 16, 2005, 02:44:41 AM EST
I disagree with, "Fixed!"
- (
ben_tilly)
- Jan. 19, 2005, 11:59:54 PM EST
Remember, people in 1900 didn't know what an atom was. They didn't know its structure.
They also didn't know what a radio was, or an airport, or a movie, or a television, or a computer, or a cell phone, or a jet, an antibiotic, a rocket, a satellite, an MRI, ICU, IUD, IBM, IRA, ERA, EEG, EPA, IRS, DOD, PCP, HTML, internet. interferon, instant replay, remote sensing, remote control, speed dialing, gene therapy, gene splicing, genes, spot welding, heat-seeking, bipolar, prozac, leotards, lap dancing, email, tape recorder, CDs, airbags, plastic explosive, plastic, robots, cars, liposuction, transduction, superconduction, dish antennas, step aerobics, smoothies, twelve-step, ultrasound, nylon, rayon, teflon, fiber optics, carpal tunnel, laser surgery, laparoscopy, corneal transplant, kidney transplant, AIDS... None of this would have meant anything to a person in the year 1900. They wouldn't know what you are talking about.
119 ms