Subject Re: [Firebird-Architect] Can we, can we, can we????...
Author Jim Starkey
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