 | | 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. (...) (22 years ago, 7-Jul-02, to lugnet.build)
|
| |
| | 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)
|
| |
| | Re: Suggestions (was: BI Portal site re-launches!)
|
|
(...) 3. The "remember me" checkbox always defaults to "Yes", but I prefer to use "no" on computers which other people may use (work, etc). Can this setting be remembered as a cookie? ROSCO (22 years ago, 8-Jul-02, to lugnet.build)
|
| |
| | 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 (...) (22 years ago, 9-Jul-02, to lugnet.build)
|
| |
| | 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)
|
| |
| | Re: BI Portal site re-launches!
|
|
(...) The downside to denormalizing is you have to remember to update your data in several places whenever you update it. Depending on how complex you want to make your code it can be worth it to denormalize in some places to allow quicker searches. (...) (22 years ago, 9-Jul-02, to lugnet.build, lugnet.off-topic.geek)
|
| |
| | Re: BI Portal site re-launches!
|
|
(...) It also depends on the database usage - if updates are frequent, de-normalised databases start losing their efficiency, but with a database such as this, that shouldn't be a big issue. You can make the update code simpler by using stored (...) (22 years ago, 10-Jul-02, to lugnet.off-topic.geek)
|
| |
| | Re: BI Portal site re-launches!
|
|
(...) And once a day, run a script to recalculate all of the counts from scratch, to make up for any bugs or irregularities or problems that cause the counts to go bad. Steve (22 years ago, 10-Jul-02, to lugnet.off-topic.geek)
|
| |
| | Re: BI Portal site re-launches!
|
|
(...) Bugs?? Irregularities????? I've never seen such things! From whence do they come? Of course, I've seen many "undocumented features" 8?) ROSCO (22 years ago, 10-Jul-02, to lugnet.off-topic.geek)
|
