Why not just test it?
Create a file with some number of records. Write a simple program to
select the file and change one character in the record. Write it back
to the file. Time it.
Add an AFTER UPDATE trigger calling a subroutine that does *nothing*
but a RETURN. Run the program again. Time it.
You have your overhead answer.
Don't ask opinions of pontificators when the machine will tell you the
truth.
Regards,
Clif
--
W. Clifton Oliver, CCP
CLIFTON OLIVER & ASSOCIATES
Tel: +1 619 460 5678 Web: www.oliver.com
On Oct 7, 2008, at 8:22 PM, Mike Roosa wrote:
We are getting ready to implement triggers on a universe system
running
under Windows Server 2003. I created a trigger and tested it out
and it
appears to do exactly what we need. My question is are there any
gotchas or
issues we should be concerned about with triggers? Are there any
performance issues that anyone has seen related to triggers?
Thanks,
Mike Roosa
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
