Re: triggers/stored procedures/SYSTEM command

Posted in 1996

Toby Denbow — Fri, 16 Aug 1996 09:27:29 -0400 — source: Informix-list mailing list archive (1991-1998)

The performance you are noticing is suprising to me. I have used the SYSTEM command from within stored procedures without any performance problems. Have you thrown in any timing checks to make sure it is really the SYSTEM call that is the problem and not the actual UNIX program that is being run? -Toby Denbow tdenbow@mathworks.com In article <320F4769.41C67EA6@ll.mit.edu>, "Willet I Beavers Jr [Bill]" <bbeavers@ll.mit.edu> wrote: > I am looking for advice on triggers and stored procedures. > I am wanting a trigger to execute a UNIX command/user > program. The simple test program I have written uses the > SQL SYSTEM command, but is incredibly slow. Any suggestions > would be greatly appreciated. It would need to be an order > of magnitude faster for this to be of much use. Perhaps > there is some other method for executing a user program > from Informix which I have not discovered. Thanks in > advance. > > Bill Beavers == Toby Denbow ========================= tdenbow@mathworks.com == The MathWorks, Inc. info@mathworks.com 24 Prime Park Way http://www.mathworks.com Natick, MA 01760-1500 ftp.mathworks.com ==== Tel: 508-647-7243 ==========================================