Re: Response Time

Y Wanda Zeng wrote: > } > 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. Since this being written at 2:30am and I have to take my dad to a doctors appointment later this am, I'll be brief. First, collect a series of sql statements you want to run. You can then do one of two things. 1) Place them all in a single file 2) Place them in separate files, one per file. Then you can either execute the UNIX command time on each file or time on the single file. (Something like time isql < filename) [I forget the syntax for isql right now.] This will give you the system time spent on executing your thread. You can also write esql/c programs which you would call time() as a C function before and after each sql statement to determine roughly the time it took to execute the statement. See K&R second ed. on time.h for more details. Again the revelancy of this is for relative times or benchmarks. So take the results with a grain of salt. In other words, don't put too much faith in benchmarks. The above use of time and time() will let you see if there are any changes when you port to either a different platform, or you modify your database layout or its parameters. HTH -- #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. *****************************