do triggers slow updates down severly
From: jack <jack.beukering_at_services.fujitsu.com>
Date: 10 Oct 2002 07:41:04 -0700
Message-ID: <531b15de.0210100641.5f228f73_at_posting.google.com>
Date: 10 Oct 2002 07:41:04 -0700
Message-ID: <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.
Doe somebody has any experience with such a case?
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?
Jack Received on Thu Oct 10 2002 - 16:41:04 CEST