Re: Response Time
Posted in 1997
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration, Platform-Specific Issues
At 11:16 AM 8/29/97 +0100, you wrote: }Y Wanda Zeng wrote: }> }> We are running Informix Online Dynamic Service 7.23 UC1 in an RS6000 with }> AIX 4.0. We have tried to create a script to measure the response time of }> each command and report it. But we have not got any luck yet. Has anyone out }> there had any idea of this response time, will be willing to give an example }> of their script or any suggestions? }Well, }You could write a simple batch file, then use the UNIX time }command when executing it. } }Or you could write an esql/c program using the time() }c functions. (See time.h) } }Using time will give you a number, however, it is very subjective }based on machine load, etc ... } }If you are going to do a benchmark, I'd run it 5 or 6 times }during the day and average them. } }-Mikey }-- }#include <std_disclaimer.h> /* Mike Segel (MS385) */ }#include <No_Spam.h> }#ifdef OFFENDED_BY_CONTENT }The author takes no responsibility for this post. }Any resemblence to a coherent rational thought is purely coincidence. }-The Management. }#endif }***************************** }Due to AGIS's Refusal to Act Responsibly }We are blocking all of their domains at the packet level. }This block will exist until AGIS modifies their policies to }conform to existing RFCs and net community standards. } }We encourage all ISPs and domain holders to do the same. }***************************** } } Mike, Thank you very much for your input. Would you tell me more detail about those "batch file" or "c program". Also please show me how to catch all those commands when they going through the Informix box. I greatly appreciate your help. Wanda Zeng, DBA email: zeng@wsu.edu Information Technology FAX: (509) 335-0540 Washington State University Phone: (509) 335-1697 PO Box 641222 Pullman, WA 99164-1222