Re: streaming result sets: progress

From: snpe <snpe(at)snpe(dot)co(dot)yu>
To: Scott Lamb <slamb(at)slamb(dot)org>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: streaming result sets: progress
Date: 2002-11-23 20:52:26
Message-ID: 200211232052.26187.snpe@snpe.co.yu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Prasanna Phadke 2002-11-25 06:45:42 Difference in the actual and extracted values of timestamp
Previous Message Stuart Robinson 2002-11-23 15:50:56 Re: