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
|
|
|
|