To LUGNET HomepageTo LUGNET News HomepageTo LUGNET Guide Homepage
 Help on Searching
 
Post new message to lugnet.buildOpen lugnet.build in your NNTP NewsreaderTo LUGNET News Traffic PageSign In (Members)
 Building / 12291
12290  |  12292
Subject: 
Re: BI Portal site re-launches!
Newsgroups: 
lugnet.build
Date: 
Sun, 7 Jul 2002 13:33:22 GMT
Highlighted: 
(details)
Viewed: 
797 times
  
In lugnet.build, Ross Crawford writes:

Looks good! One thing I noticed (and you've probably already tossed this
around) is maybe each category / sub-category should display the total
number of submissions in the tree below it.

Yep, I have actually thought about this, and it is one of the most common
comments I have gotten. I would love to do this, and have actually played
around with it. The problem is that it is incredibly inefficient for the
code/database. Basically, each time I display a category, or a list of
categories with their link count next to it, I would have to traverse the
entire category table to find the very bottom for each category in question.
Then I would have to climb the category tree back up counting and/or
displaying along the way. This is a healthy load on the database and user
load times.

That being said, I am working on some alternate methods of displaying all
links (not all by category, simply all) which might help some people out.
More info on this soon.


The reason I say this is, when I
go to "Trains", the "Locomotives" sub-category has zero next to it, so if I
didn't know better (ie a new visitor) I'd assume there was none, and go no
further. Or maybe show the number of sub-categories next to it? But I'd
prefer the former.

I made a tweak this morning. The category sidebar now looks like this:

SubCategory Name (link count in this subCat)
SubCats: (Number of subcats under that particular subcat)

Check it out and let me know if that helps. And keep the suggestions coming!

Jake

---
Jake McKee
LEGO Enthusiast
LUGNET Member #211
Webmaster - BI Portal



Message has 2 Replies:
  Re: BI Portal site re-launches!
 
"Jake McKee" <sink@countersinkdg.com> schrieb im Newsbeitrag news:GyvsBM.87D@lugnet.com... (...) Why not simply do this calculation each time an instruction is added? Then you won't have to do it a view hundred times a day for each view, but only a (...) (22 years ago, 7-Jul-02, to lugnet.build)
  Re: BI Portal site re-launches!
 
(...) As Oliver says, de-normalising the database may be an effective way of reducing the server load. Store the tree total against each category, and update it when a link is submitted. (...) Yep! But I dunno if I like light grey - kinda looks like (...) (22 years ago, 8-Jul-02, to lugnet.build)

Message is in Reply To:
  Re: BI Portal site re-launches!
 
(...) Thanks, Jake Looks good! One thing I noticed (and you've probably already tossed this around) is maybe each category / sub-category should display the total number of submissions in the tree below it. The reason Isay this is, when I go to (...) (22 years ago, 6-Jul-02, to lugnet.build)

20 Messages in This Thread:








Entire Thread on One Page:
Nested:  All | Brief | Compact | Dots
Linear:  All | Brief | Compact

This Message and its Replies on One Page:
Nested:  All | Brief | Compact | Dots
Linear:  All | Brief | Compact
    

Custom Search

©2005 LUGNET. All rights reserved. - hosted by steinbruch.info GbR