Re: streaming result sets: progress - Mailing list pgsql-jdbc

From snpe
Subject Re: streaming result sets: progress
Date
Msg-id 200211232052.26187.snpe@snpe.co.yu
Whole thread Raw
In response to Re: streaming result sets: progress  (Scott Lamb <slamb@slamb.org>)
List pgsql-jdbc
On Saturday 23 November 2002 03:20 pm, Scott Lamb wrote:
> 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.
>

Are you sure ?
When PostgreSQL work with cursors - execute and fetch are two command for backend
I know that other database work separatly and PostgreSQL work together without cursors
and we will choose

regards
Haris Peco

pgsql-jdbc by date:

Previous
From: Stuart Robinson
Date:
Subject: Re:
Next
From: Prasanna Phadke
Date:
Subject: Difference in the actual and extracted values of timestamp