Viewing 15 posts - 52,936 through 52,950 (of 59,064 total)
they take pride in what they do, and they don't want to hear they've built a POS when they're doing their best
I've gotta disagree with you there, ol' friend. ...
January 12, 2008 at 9:21 pm
And, I gotta disagree... this isn't a triangular join... internally generated rows to not form the classic triangle. No table has more rows spawned than either of the original...
January 12, 2008 at 9:03 pm
I was just busting your chops earlier - you know that right?
Oh yeah... just got me thinking...
January 12, 2008 at 8:59 pm
Ok... you certainly shouldn't post that data... it contains private information and understood about the source code.
Here's the real key... you're using an application to insert 2.2 million rows, one...
January 12, 2008 at 3:51 pm
On second thought, it's not a triangular join... for a count of 3, a triangular join would generate...
1
1 2
1 2 3
... to get the count... 6 rows total. This...
January 12, 2008 at 12:57 pm
Heh... yeah... it is... 😛
Difference is that all rows it touches are generated in the output... nothing wasted. Like I said in the article, they're not all bad...
... I...
January 12, 2008 at 12:49 pm
Heh... what happened to 150 questions?
The real problem with the way you wanted to do it is that if most of your questionaires only have 50 questions and you have...
January 12, 2008 at 12:33 pm
It sounds like you're getting data from a file, cleaning it up, and then inserting it into a database... For 2.2 million rows, this shouldn't take more than a minute...
January 12, 2008 at 12:02 pm
Heck yeah there would be performance issues... performance would increase because you could properly index it 😀
January 12, 2008 at 11:08 am
simon.letts (1/9/2008)
To make it easier ...lets say that I just have a table with just one column, trans_code...
January 12, 2008 at 10:30 am
You would get a lot of help if you'd at least identify what it is what you want to do... 😉
But I understand... sometimes you're in a bit of a...
January 12, 2008 at 9:44 am
k.furness (1/12/2008)
This is single table that contains the following Fields:
ID [int] Identity
QuestionnaireID [int]
Q0 [smallint]
.
.
.
Q150 [smallint]
Don't think I can get it any normalized than it is, but if I...
January 12, 2008 at 9:29 am
Heh... go around talking like those words, and you'll be labeled as pompous a$$ for sure...
January 11, 2008 at 9:55 pm
If you have an answer to this, Ananth, just tell us... 😉
January 11, 2008 at 9:40 pm
Viewing 15 posts - 52,936 through 52,950 (of 59,064 total)