Hi Mel
UniVerse 10.1.2
AIX 5.2
We've found triggers to be immensely slow. At first we thought it might be the
files to which we were writing, but then, on the suggestion of another list
member, we tested with a trigger that was only 2 lines long (ie the SUBROUTINE
statement and a RETURN), ie that did absolutely nothing. This is what we
found:
- a write of 500 000 records to a file:
- without a trigger 63 seconds
- with an empty trigger 677 seconds
Discussion with IBM suggested we change the filing system on our IBM box, but
as yet this has proved inconclusive. There was one member of this list,
running on Solaris, who found excellent results, but others had the same
problems we had.
As a result, we dare not go anywhere near triggers
-----Original Message-----
From: Maresh, Mel [mailto:[EMAIL PROTECTED]
Sent: Thursday, 14 October, 2004 6:55 PM
To: [EMAIL PROTECTED]
Subject: [U2] [UV] Triggers
We have recently upgraded to v10.1 and are reconsidering the use of triggers
after encountering significant issues with triggers with v9.4. After
successfully testing them in our development environment, we encountered
random write failures in production.
Has anyone experience with triggers at both version levels? If so, is the use
of triggers on non-SQL files, which is now possible, more robust and more
efficient than on SQL files in 9.4?
It has been suggested that we use indexes instead of triggers in the following
way
1. Create an I-descriptor on a file that calls a subroutine 2. Create the
subroutine to always return a null value 3. Index the I -descriptor with the
no-null option
Any time a write is made to the file from any program including the editor,
Universe will attempt to update the Index. However the index will not be
updated as the returned value is always null. In the meantime the subroutine
called to evaluate the value is free to do what we wanted the trigger to do.
This apparently was common before triggers became available. Has anyone had
experience with this?
Any help would be greatly appreciated
Mel Maresh
NextiraOne LLC
IT Senior Developer
713.307.4256
[EMAIL PROTECTED]
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---------------------------------------------------------
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
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
