 | | Re: BI Portal site re-launches! —Larry Pieniazek
|
| | | (...) 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! —Jude Beaudin
|
| | | | (...) 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! —Ross Crawford
|
| | | | (...) 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! —Steve Bliss
|
| | | | (...) 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! —Ross Crawford
|
| | | | (...) 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)
|
| | | | |
