Re: SP URGENT HELP: SYSTEM .. to keep a log file

For SPL to run a SYSTEM command it must 'shell-out'. This will be done using fork() & exec() which will copy your database process / thread and then copy ksh over the top of it before executing the 'echo' command. This is very expensive. How about storing the 'text' in a working database table and viewing it with a form ? Storing the field as varchar will keep the disk usage to a minimum. An overnight SQL script could be used to delete / archive the data if this is a long term requirement. Mike. In article <01bbdc4f$082fd460$7e8a989e@gcp-client>, George C Parobek <george@icc-gcp.demon.co.uk> writes >I am using SP for Client Server application. >In order to monitor and check the update procedures I need to log the >progress in a unix text file. e.g.: > > SYSTEM "echo "||text||" >> log_file"; > >This command takes too long top process, cca. 1sec !!!!!! > >Is there a better way of achieving the same goal. > >Please HELP -- Mik Hobbs