Subject:
|
Re: BI Portal site re-launches!
|
Newsgroups:
|
lugnet.build
|
Date:
|
Tue, 9 Jul 2002 12:18:30 GMT
|
Viewed:
|
799 times
|
| |
|
|
In lugnet.build, Ross Crawford writes:
> 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.
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?
> > 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...).
Well, the gray was just meant as a way to visual separate the content a
little. I will play with some other ideas as I get time.
> 1. When I edit a link, the current category isn't the default - I have to
> re-select it. Can this be easily changed?
This is on the to-do list... It is actually much more complicated than it
seems because of several factors. I definitely want to get it changed though.
> 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...
Can you contact me off line about this? I am not sure what you mean about
"hi-jacking". I checked the DB as soon as you posted this message and there
was only one entry for your email address, so I'm not sure what problem you
noticed.
As far as the "Remember me" checkbox, I will add that to the list too.
Thanks for the suggestions!
Jake
---
Jake McKee
LEGO Enthusiast
Webmaster - BI Portal
|
|
Message has 1 Reply:
 | | Re: BI Portal site re-launches!
|
| (...) Normalising makes things more space efficient (by reducing storage of redundant information), denormalising makes things more efficient at runtime (by reducing joins). Storing the tree total against each category is an example of keeping (...) (22 years ago, 9-Jul-02, to lugnet.build)
|
Message is in Reply To:
| | 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)
|
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
|
|
|
|
