|
|
Posted by ZeldorBlat on 10/04/06 01:24
Jonas Smith wrote:
> On Sat, 30 Sep 2006 20:23:49 -0400, ZeldorBlat wrote
> (in article <1159662229.568323.198440@c28g2000cwb.googlegroups.com>):
>
> > Jonas Smith wrote:
> >> The first question is:
> >>
> >> Can the trigger be set to do the calculation only when the
> >> totalColumn is updated? The access column is updated quite often (as
> >> well as other columns) and to trigger the calculation any time any
> >> of the columns is updated would put undue load on the servers.
> >>
> >> Second question:
> >>
> >> What is the syntax for this kind of trigger?
> >
> > I don't think MySQL will let you define a trigger that only fires when
> > certain columns are updated (some other databases do).
>
> That's what I thought, I just needed the confirmation. And since this is
> the case, a trigger for this function is not worth the effort and will
> put undue load on the servers.
How do you know unless you try it? I'd honestly be surprised if it
truly presented a performance problem.
Navigation:
[Reply to this message]
|