Re: do triggers slow updates down severly
From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Thu, 10 Oct 2002 15:18:30 GMT
Message-ID: <aTgp9.41001$ST4.88157_at_rwcrnsc53>
Date: Thu, 10 Oct 2002 15:18:30 GMT
Message-ID: <aTgp9.41001$ST4.88157_at_rwcrnsc53>
Try it. Benchmark it, don't go on anecdotal evidence. I bet you won't
notice much of a difference.
Jim
"jack" <jack.beukering_at_services.fujitsu.com> wrote in message
news:531b15de.0210100641.5f228f73_at_posting.google.com...
> I want to use update trigger to record the timestamp, so I know the
> mutation dates of records. Inserts can be handled by a default
> declaration of the timestamp column.
> My question is, does the performance of batch-jobs suffers serverly at
> e.g. 10.000 records or do you start to notice it at 100.000 records?
>
> Doe somebody has any experience with such a case?
>
> Jack
Received on Thu Oct 10 2002 - 17:18:30 CEST