Scott Lamb <slamb@slamb.org> writes:
> snpe wrote:
> > Yes, it is legitime, but execute and fetch are separated command.
> > There isn't good reason for doing fetch with execute - maybe user never call fetch.
>
> Network efficiency. By batching the commands together, it avoids a round
> trip to the database server.
And it's very likely that once a ResultSet is got, the user will want
to position it.
The number of times that this doesn't happen is, well, I've never
done it.
Nic