Subject:
|
Re: BI Portal site re-launches!
|
Newsgroups:
|
lugnet.build
|
Date:
|
Mon, 8 Jul 2002 01:31:04 GMT
|
Viewed:
|
906 times
|
| |
|
|
In lugnet.build, Jake McKee writes:
> 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.
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.
> > 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.
Yep! But I dunno if I like light grey - kinda looks like it's un-important
(which I guess is subjective anyway...).
> And keep the suggestions coming!
Okee dokee.
1. When I edit a link, the current category isn't the default - I have to
re-select it. Can this be easily changed?
2. Someone else registered my email - I just chose "forgot password" and
changed the password, but thought you should know people may be hi-jacking
emails...
ROSCO
|
|
Message has 2 Replies:
 | | Re: BI Portal site re-launches!
|
| (...) Can you explain this a little more? I intrigued by the concept, and completely confused. My (limited) knowledge of databases tells me that normalizing the DB is a way to add efficiency. What I am missing in your suggestion? (...) Well, the (...) (23 years ago, 9-Jul-02, to lugnet.build)
|
Message is in Reply To:
| | Re: BI Portal site re-launches!
|
| (...) 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. (...) (23 years ago, 7-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
|
|
|
|
