Subject:
|
Re: BI Portal site re-launches!
|
Newsgroups:
|
lugnet.off-topic.geek
|
Date:
|
Wed, 10 Jul 2002 20:55:38 GMT
|
Viewed:
|
995 times
|
| |
|
|
In lugnet.off-topic.geek, Ross Crawford wrote:
> You can make the update code simpler by using stored procedures and / or
> triggers. You can write a trigger on "insert instruction" to add 1 to the
> category count, etc., then whenever a new link is submitted the category
> total is always updated correctly.
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
|
|
Message has 1 Reply:
Message is in Reply To:
 | | 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)
|
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
|
|
|
|
