Alexandre Benson Smith wrote:

>I agree with you that the number of fetches are a etereal measure for we
>(me) simple mortals. But as mentioned to track the execution time will
>be hard. I don't know about how difficult it is.
>
>

CPU time is impossible to get per thread. Elapsed time isn't good
enough to be useful.

>But one can say for example that an upper limit of 50000 (just a sample)
>page fetches could be the upper limit.
>
>My second question, now I know what fetches are, is:
>
>1.) The partial result set will be returned to the user ?
>
>

No. An error return means results are unavailable.

>2.) If the answer for the question 1 = true then a flag wll be returned
>indicating that this is a partial result set ?
>3.) If the answer for the question 2 = true the user could ask to
>process N more fetches ?
>
>

No. The request must be unwound to return the error. There is no way to
preserve the state of the request at the point it failed.


--

Jim Starkey
Netfrastructure, Inc.
978 526-1376