Tutorial Count - Help Module [Lead: Phil Beadle]

Forum DotNetNuke® Pro... Help Module [Le... Tutorial Count

10/14/2006 8:53 PM

	Mike
10 posts
www.DNNSpired.com

Tutorial Count

Is there any way to get a tutorial count next to each category?

Something like this:

Help Category 1 (4)
Help Category 2 (1)
Help Category 3 (17)

Thanks Mike Florida US

1/16/2007 5:05 PM

	Philip Beadle
1165 posts
www.philipbeadle.net

Re: Tutorial Count

I'll have a think about this. to do this we would need to interrogate the category_Tutorials table for each category which may impact performance too much. But ill have a look.

Philip Beadle (DNN Core Team)
My Blog
My DNN Blog
TDD DNN Module Template

1/16/2007 5:51 PM

	Mike
10 posts
www.DNNSpired.com

Re: Tutorial Count

Thanks for the reply.

Yes. I see where you would be concerned about performance when interrogating another table. If that does turn out to be a problem then maybe the value could be calculated and stored in a field in the Help_Category table during tutorial update?

I guess there will always be the battle of Normalization Vs Performance.

Thanks Mike Florida US

1/16/2007 6:03 PM

	Jon
84 posts

Re: Tutorial Count

philip.beadle wrote
I'll have a think about this. to do this we would need to interrogate the category_Tutorials table for each category which may impact performance too much. But ill have a look.

I'm not sure what you're thinking, but one of these queries would do it simply enough.

The query that is currently getting the category names could be altered to behave like so:

select cat.CategoryID, cat.Name, count(*) as TutorialCount
from Help_TutorialCategory tut
join Help_Category cat on cat.CategoryID = tut.CategoryID
group by cat.CategoryID, cat.Name

Or this query would return just the category IDs and counts:

select CategoryID, count(*) as TutorialCount
from Help_TutorialCategory
group by CategoryID

A simple trace would tell me what queries are currently being used and it is likely that one of those could be altered to return the counts without much performance impact, since no additional queries would be required. However, I have rotten luck with 2.0.4 and I'm looking forward to 3.0.0. If I can get 3.0.0 working, I'll take another look at this.

1/17/2007 4:23 PM

	Philip Beadle
1165 posts
www.philipbeadle.net

Re: Tutorial Count

Thanx Jon,

I'll try out your sql and see how it goes. If teh impact isnt noticeable then Ill add it as an enhancement in the next release.

Philip Beadle (DNN Core Team)
My Blog
My DNN Blog
TDD DNN Module Template

Page 1 of 2

Forum

DotNetNuke® Pro...

Help Module [Le...

Tutorial Count