Jeff
Triggers that have little effect on performance would indeed be ideal.
Alas, our experiments (prompted by Adrian Matthews post) have lead to
the firm decision to stay away from triggers as implemented in
UniVerse...
A trigger that merely activated (ie a two line program having a RETURN
statement as line 2) doing nothing takes 10 to 15 times as long to
complete
eg without a trigger, 500 000 records takes 60.3 secs to copy
with a empty trigger, 500 000 records took between 600 & 700
secs!!!
This sure sucks!
-----Original Message-----
From: Lettau, Jeff [mailto:[EMAIL PROTECTED]
Program triggers that keep all the databases updated virtually in real
time sounds like the best real world solution to me.
<PRE>
---------------------------------------------------------
GWK BEPERK/LIMITED (REG: 1997/022252/06)
POSBUS 47 PO BOX 8730
DOUGLAS
Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes,
JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit,
JP Snyman, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl,
Sekr/Secr: E van Niekerk.
Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by:
http://www.gwk.co.za/DisclaimerVrywaring.asp
This e-mail is subjected to the disclaimer that can be viewed at:
http://www.gwk.co.za/DisclaimerVrywaring.asp</PRE>
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
