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

I know no way to write to a file faster than this. You might however insert the log info into a table inside the stored procedure instead of writing to a file. That would be much faster, and it should be easy to get at the data at any time. If you *must* have it in a file you could run another process that reads from the log table, writes to a file and deletes or mark the records as they are written. "George C Parobek" <george@icc-gcp.demon.co.uk> wrote: :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 :-- :george@icc-gcp.demon.co.uk Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org