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