> Has anyone experience with triggers at both version levels? We have both file-triggers (sql & non-sql) and index-triggers on our system. We have used index triggers from version 9.4 through to 10.0.7. and file-triggers with v10.
Performance-wise, there doesn't seem to be too much difference. Maintenance-wise, I think the index triggers are more fragile but that's just the way they were architected here. There are also issues using index-triggers within a transaction. We had a deadlatch issue using a file with an index trigger. The index i-type read the file that was being updated and regardless of the locking we used caused a deadlatch. We replaced the index trigger with a file trigger and the problem went away. Remember that triggers work transactionally. So, if for example, the update that fires the trigger fails, or if you use the setDiagnostics() function in the trigger program, then any file I/O actions the trigger makes will be rolled back. You cannot use a file trigger on a UVNet file updated remotely, though an index trigger may work in that situation. I haven't had any other problems using file triggers within version 10. Regards, Stuart ********************************************************************** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ********************************************************************** ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
