We did use them extensively in our applications for updating audit files, referential integrity checks etc etc. All fairly normal things.
Performance was terrible and got worse (obviously) the more transactions we did. However nearly all our software is real-time and there is very rarely a user on the front of it. A trigger in a normal data entry program would be fine, the user wouldn't even notice. Personally I would avoid them for time-critical batch updates or milli-second dependent real-time updates. They are very useful for more traditional programs though. Now that we run Universe replication we can't run triggers at all as they are not supported on replicated files. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rex Gozar Sent: 15 October 2004 14:15 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Triggers Some thoughts in regards to Dennis' observation that triggers are slow. I would kinda expect them to be slow. After all, they are (essentially) little programs that get run each time a record is changed. Even if the trigger did nothing, some overhead is expected for processing each record. I'm curious about performance differences between traditional update programs and triggers. Writing 500 000 records with and without a trigger only tells us that triggers have overhead, but how would you measure the performance difference of moving actual functionality from a traditional program to a trigger? For example, let's say I have a data-mangling function implemented in a subroutine that's called from various programs during record updates. If I were to rip the data-mangling subroutine out of the entry programs and move it to a trigger, what kind of performance would I gain/lose? This would be a more meaningful metric to me -- if the trigger was significantly slower, I would probably avoid triggers. Has anyone out there performed any trigger benchmarks like this? I'm guessing "no". Another consideration is maintenance programming. Triggers can simplify both the initial design and maintenance of software systems, which is why they are popular in other databases. Like a lot of things in technology, they can be misunderstood and abused. Used wisely, triggers can help in managing software complexity. REX ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/