RE: [U2] Trigger not intensive, it's what you do with trigger! Wa s RE: [U2] Dot Commands

2004-09-01 Thread Dennis Bartlett
Alas! I have to return with my tail 'tween my legs! --- IBM P615 AIX 5.2 Universe 10.1.2 2 cpu --- Test Data : 500,000 invoice records, a trigger with a RE

RE: [U2] Trigger not intensive, it's what you do with trigger! Wa s RE: [U2] Dot Commands

2004-09-01 Thread Adrian Matthews
rigger not intensive, it's what you do with trigger! Wa s RE: [U2] Dot Commands My with and without scores were 78 seconds and 80 seconds respectively. Yes, without took longer. It was 1000 updates, the same record set, and a simple RETURN after the parameters. The trigger was AFTER INSERT

RE: [U2] Trigger not intensive, it's what you do with trigger! Wa s RE: [U2] Dot Commands

2004-09-01 Thread John Reid
My with and without scores were 78 seconds and 80 seconds respectively. Yes, without took longer. It was 1000 updates, the same record set, and a simple RETURN after the parameters. The trigger was AFTER INSERT UPDATE DELETE. Maybe the INSERTS take longer or system load may have been radically diff