A question about long running queries. We have an
application that is running across a WAN. We are trapping
long running queries. Does the timing of the query
include serving the data set back to the requestor?
LYes it does. That's why it is highly recommended that a stored procedure is
used because it is only running on the server and can take advantage of
cached plans.
"Laurel" <landj.griffith@.attbi.com> wrote in message
news:4e0801c48098$347dcae0$a301280a@.phx.gbl...
> A question about long running queries. We have an
> application that is running across a WAN. We are trapping
> long running queries. Does the timing of the query
> include serving the data set back to the requestor?
> L
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment