Yes, I am being naughty and posting a technical question, but I don't
believe I am signed up to the cf-talk list right now. Besides, all the
smart folks hang out here anyway ;)
I have been asked to get info out of a group of tables. Duh, right? Well,
the problem is, the main table that links
Check your indexes on your columns to make sure you are not doing a table
scan somewhere.
After that, you might try re-writing your query a little. I'll give this a
shot, just an experiment:
SELECT c.Cat, v.MC, v.CatID, v.VideoID, v.MovieTitle, SUM(s.TotalTime)
FROM catagories c
JOIN videos v
SELECT c.Cat, v.MC, v.CatID, v.VideoID, v.MovieTitle, SUM(s.TotalTime)
FROM catagories c, videos v, users u, salesreport s
WHERE u.ADVID 0
AND u.UserID = s.UserID
AND c.catid = v.catid
AND v.videoid = s.videoid
GROUP BY v.VideoID
ORDER BY c.Cat
Please include table schema's,
Whenever I make a post, it doesn't show up until someone replies to it.
Odd. Anyway ..
All columns referenced are indexed. salesreport is the 7.5 mil recod
table. The query should only return a few hundred rows at the most. I will
try the one you provided and play with the order a bit.
Todd, it's gmail, not HoF. Happens to me too. Something about a unique
ID being assigned to the gmail thread or something, Mike D explained it
to me a while ago, but I forget the reason. I just accept it now.
Ray
Todd Ashworth wrote:
Whenever I make a post, it doesn't show up until someone
OMG Todd!!! Where you people been hiding? A party I wasn't invited to???
Cheers,
Erika
Hugging Prez Todd for a healthier tomorrow
--
##| -Original Message-
##| From: Todd Ashworth
OMG Jochem Long time no readie ...
Hope all is well!
Cheers,
Erika
--
##| -Original Message-
##| From: Jochem van Dieten
~|
Message:
The report needs to show:
MC cat catid videoid MovieTitle and total time watched for each movie
MC is the Master Category. cat is the sub category.
It would look like this:
SportsRafting 7 1657 Rafting for Dummies 23 hours 57 minutes 11
seconds
SportsSkyDiving 27 9987
I have been ... busy :) No parties for Todd. Running a country is a full
time job.
On 3/30/06, Erika L. Walker [EMAIL PROTECTED] wrote:
OMG Todd!!! Where you people been hiding? A party I wasn't invited to???
Cheers,
Erika
Hugging Prez Todd for a healthier tomorrow
Damn, when did the President Todd stuff start?
That's been like 6 years go now.
-Original Message-
From: Todd Ashworth [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 30, 2006 1:50 PM
To: CF-Community
Subject: Re: Prez Todd [was RE: OT: query help]
I have been ... busy
Add an index to videos.CatID. That is almost certainly a problem, given that
you are joining that table to the huge table. I might also add an index to
catagories.Cat because you are ordering by that field, although that
operation should not be expensive in the select.
On 3/30/06, Todd Ashworth
Yups, long time ago, back in 2001.
We keep re-electing him. He's the best. Knits sweaters and all whilst
running the country. :)
Cheers,
Erika
--
##| -Original Message-
##| From: Nick McClure
##|
##| Damn, when did the President Todd
Yeah .. sometime in the early part of 2000, I believe.
President Todd
---
Reliving the good ol' days for a better yesterday.
On 3/30/06, Nick McClure [EMAIL PROTECTED] wrote:
Damn, when did the President Todd stuff start?
That's been like 6 years go now.
hah! I keep forgetting about the sweaters.
Whatever happened to the abundance of muffins that used to be found around
these parts? oh and *looks around cautiously* .. the frying pan?
On 3/30/06, Erika L. Walker [EMAIL PROTECTED] wrote:
Yups, long time ago, back in 2001.
We keep re-electing
To: CF-Community
Subject: RE: Prez Todd [was RE: OT: query help]
Damn, when did the President Todd stuff start?
That's been like 6 years go now.
-Original Message-
From: Todd Ashworth [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 30, 2006 1:50 PM
To: CF-Community
Subject: Re: Prez
That did it. It takes almost 2 minutes for the thing to run, but at least
it runs now. Thanks!
On 3/30/06, Robert Munn [EMAIL PROTECTED] wrote:
Add an index to videos.CatID. That is almost certainly a problem, given
that
you are joining that table to the huge table. I might also add an
[was RE: OT: query help]
Yeah .. sometime in the early part of 2000, I believe.
President Todd
---
Reliving the good ol' days for a better yesterday.
On 3/30/06, Nick McClure [EMAIL PROTECTED] wrote:
Damn, when did the President Todd stuff start?
That's been like 6 years go now
No. I made some vague threats like 2 months ago, or so. =-)
I have been gone a long time though. I'm sure the people that have joined
the list during my absences are like, WTF are they on about?
On 3/30/06, Loathe [EMAIL PROTECTED] wrote:
I don't think it's been that long since the threat
Yes, yes we are :)
No. I made some vague threats like 2 months ago, or so. =-)
I have been gone a long time though. I'm sure the people that have joined
the list during my absences are like, WTF are they on about?
~|
heh .. You are not alone .. well, about the old part anyway ;)
On 3/30/06, Loathe [EMAIL PROTECTED] wrote:
Great,
So I'm insane and old.
Today sucks.
--
Timothy Heald
~|
Message:
Hey, great! Glad to confuse you!
PT
-
Confusing the CF community for a better tomorrow.
On 3/30/06, G [EMAIL PROTECTED] wrote:
Yes, yes we are :)
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:202350
No. I made some vague threats like 2 months ago, or so. =-)
Sir, may I remind the President that the President does not make
threats, he 'resolves matters through diplomatic channels.'
--
will
If my life weren't funny, it would just be true;
and that would just be unacceptable.
- Carrie
Diplomacy is overreated. I prefer to get all of the political BS out of the
way and call it like it is. At least everyone knows where they stand that
way.
And if they are still confused, a few hundred megatons should bring the
point home!
Call it, aggressive diplomacy, if you like.
PT
To answer your question, I have been doing lots of stuff. Work days are
long. I generaly leave between 6 and 7:30. I am still involved with that
Adventure Qeust game to some extent. I run a server on an IRC network and
spend much of my idle time there. I am also working with a few other
Diplomacy is like pants -- it mostly exists to cover someone's ass.
--Ben
Todd Ashworth wrote:
Diplomacy is overreated. I prefer to get all of the political BS out of the
way and call it like it is. At least everyone knows where they stand that
way.
And if they are still confused, a
Yeah sorry 2000 ... March I think, I could look it up, I have all the
emails ...
Cheers,
Erika
##| -Original Message-
##| From: Todd Ashworth
##|
##| Yeah .. sometime in the early part of 2000, I believe.
##|
##| President Todd
##| ---
##| Reliving the good ol' days for a better
you really have all the emails from way back then to now? for cf-comm?
tw
On 3/30/06, Erika L. Walker [EMAIL PROTECTED] wrote:
Yeah sorry 2000 ... March I think, I could look it up, I have all the
emails ...
Cheers,
Erika
##| -Original Message-
##| From: Todd Ashworth
##|
##|
: query help]
you really have all the emails from way back then to now? for cf-comm?
tw
On 3/30/06, Erika L. Walker [EMAIL PROTECTED] wrote:
Yeah sorry 2000 ... March I think, I could look it up, I have all the
emails ...
Cheers,
Erika
##| -Original Message
PROTECTED]
Sent: Thursday, March 30, 2006 3:34 PM
To: CF-Community
Subject: RE: Prez Todd [was RE: OT: query help]
I kept them up until a few months ago. Then I finally had to start deleting
them.
I do still have all my email from about 1996 at home.
-Original Message-
From: Tony
I really do. I have kept EVERY single CF-Comm email from when I joined
in February 2000.
:)
Cheers,
Erika
Yes, I know I am a freak ...
--
##| -Original Message-
##| From: Tony
##|
##| you really have all the emails from way back then to
30 matches
Mail list logo