Re: accept ... from time

I want to measure the execution time of a sql statement. Can I get the
time in milliseconds to be displayed.

Call me an old fuddy-duddy, but millisecond accuracy s going to be so
dependent on other factors such as current demands on database server and
current network traffic that milliseconds are meaningless

"But," says you, " I willl be doing THOUSANDS of these and those
milliseconds will add up in a big hurry!"

The obvious answer is ... do your thousands of executions and divide by the
number of same to get a 'unit time cost.' Hell, this will be more accurate
than doing onesies and twosies anyway.

(Ummm....I assume the statement is already PREPARED? Otherwise the
preparation time (parse and plan) will be inseparable from the execution
time).

--
Michael C. Mattias
Tal Systems Inc.
Racine WI
mmattias@xxxxxxxxxxxxxx


.

Relevant Pages

  • Re: GetSystemTime and millisecons
    ... I try resive milliseconds in WinCE4.2. ... I look at platform builder source code this command and see that it is not get milliseconds from system, ... How I can recive millisecond connecting with system time? ... We did not need millisecond accuracy in the end accurate corrections!). ...
    (microsoft.public.windowsce.embedded.vc)
  • Re: Random number generation IP Sharp APL?
    ... executions. ... Often, it would be the milliseconds on TS, but often you ... clock. ... and you should have more random random ...
    (comp.lang.apl)