-Original Message-
From: Reid Thompson
Sent: Thursday, October 17, 2019 9:49 PM
To: pgsql-general@lists.postgresql.org
Cc: Reid Thompson
Subject: Re: Can you please tell us how set this prefetch attribute in
following lines.
On Thu, 2019-10-17 at 11:16 +, M Tarkeshwar Rao wrote
OciError, iters, 0,
NULL, NULL, OCI_DEFAULT );
For Postgres
Can you please tell us how set this prefetch attribute in following lines. Is
PQexec returns all the rows from the table?
mySqlResultsPG = PQexec(connection, aSqlStatement);
if((PQresultStatus(mySqlResultsPG) == PGRES_FAT
ch, 0,
> OCI_ATTR_PREFETCH_ROWS, myOciError );
> // Execute query
> status = OCIStmtExecute( myOciServerCtx, myOciStatement, myOciError, iters,
> 0, NULL, NULL, OCI_DEFAULT );
>
> For Postgres
>
> Can you please tell us how set this prefetch attribute in following lines. Is
> P
OCIAttrSet( myOciStatement, OCI_HTYPE_STMT, &prefetch, 0,
> OCI_ATTR_PREFETCH_ROWS, myOciError );
> // Execute query
> status = OCIStmtExecute( myOciServerCtx, myOciStatement, myOciError, iters,
> 0, NULL, NULL, OCI_DEFAULT );
>
>
> For Postgres
>
> Can you pl
OciError, iters, 0,
NULL, NULL, OCI_DEFAULT );
For Postgres
Can you please tell us how set this prefetch attribute in following lines. Is
PQexec returns all the rows from the table?
mySqlResultsPG = PQexec(connection, aSqlStatement);
if((PQresultStatus(mySqlResultsPG) == PGRES_FAT
