Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ASP_DRUG_DEALER
Yak Posting Veteran
61 Posts |
 Posted - 2004-08-18 : 15:38:14
|
| Hey all-I am thinking about creating a trigger that will fire and update the main table when changes are made to a rate table.If the rate changes, update all records that use this rate to get their value. I've never done something like this, so looking for the goods and bads doing it this away? Good idea or not?Thanks,Doug |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-08-18 : 15:52:08
|
| How large is the table you are considering updating once the rates change? How often do the rates change?Is it critical that the values be updated immediately? |
 |
|
|
ASP_DRUG_DEALER
Yak Posting Veteran
61 Posts |
Posted - 2004-08-18 : 15:57:47
|
| 250k in the main table, but it's only certian records will be updated when a rate changes. Rates should not change very often, maybe 3-4 times a year. |
|
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-08-18 : 16:00:03
|
| How much activity does the main table receive?The factors to consider here are how the trigger will affect performance of the other concurrent activities. |
|
|
|
|
|
|
Insert Trigger.