Re: [Sqlrelay-discussion] RE : Oracle : Prefetch ?

[David M. <dav...@fi...>]

On the server side, SQL Relay's oracle connection daemon prefetches 10
rows from the database by default.  You can tune this by setting the
fetchatonce connectstring parameter in sqlrelay.conf:

<instance id=3D"oracle8test" ...>
	...
	<connections>
		<connection connectionid=3D"db"
string=3D"user=3Dtestuser;password=3Dtestpassword;oracle_home=3D/u01/app/=
oracle/product/10.2.0;oracle_sid=3Dora1:fetchatonce=3D20" metric=3D"6"/>
	</connections>
</instance>

The SQL Relay client fetches all rows of the result set from the SQL
Relay server by default.  To conserve RAM, you can limit the number of
rows that are fetched at once using setResultSetBufferSize.  It
shouldn't limit the result set.  The code you're using should work fine.
I'll run a few tests to see what's I get and let you know what I find.

David Muse
dav...@fi...

On Tue, 2006-10-10 at 16:52 +0200, Sylvain Gourvil wrote:
> =20
>=20
> I have used the example code from the sourceforge documentation.
>=20
> =20
>=20
> The result is a =E2=80=9Climit-like=E2=80=9D.
>=20
> =20
>=20
> <?
>      dl("sql_relay.so");
> =20
>      $con=3Dsqlrcon_alloc("host",9000,"","user","password",0,1);
>      $cur=3Dsqlrcur_alloc($con);
> =20
>      sqlrcur_setResultSetBufferSize($cur,5);
> =20
>      sqlrcur_sendQuery($cur,"select * from my_table");
> =20
>      while (!done) {
>              for ($col=3D0; $col<sqlrcur_colCount($cur); $col++) {
>                      if ($field=3Dsqlrcur_getField($cur,$row,$col)) {
>                              echo $field;
>                              echo ",";
>                      } else {
>                              done=3D1;
>                      }
>              }
>              echo "\n";
>              $row++;
>      }
>=20
> ?>
>=20
> =20
>=20
> If somebody has a good code for using buffer and prefetch with sql
> relay, could he show me ?
>=20
> =20
>=20
> Thanks.
>=20
> =20
>=20
> Regards
>=20
> =20
>=20
> =20
>=20
> -----Message d'origine-----
> De : sql...@li...
> [mailto:sql...@li...] De la part
> de Sylvain Gourvil=20
> Envoy=C3=A9 : mardi 10 octobre 2006 15:26
> =C3=80 : sql...@li...
> Objet : [Sqlrelay-discussion] Oracle : Prefetch ?
>=20
> =20
>=20
> =20
>=20
> Hi everybody ?
>=20
> =20
>=20
> I am trying to put SQL Relay in a framework ans I need to deal with
> prefetch (Oracle).
>=20
> I can not find any subject about it;
>=20
> =20
>=20
> Does SQL Relay deal with prefetch?
>=20
> IF yes, could you help me?
>=20
> =20
>=20
> Thanks in advance.
>=20
> =20
>=20
> Regards.
>=20
> =20
>=20
>=20
> -----------------------------------------------------------------------=
--
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share=
 your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
> _______________________________________________ Sqlrelay-discussion mai=
ling list Sql...@li... https://lists.sourcef=
orge.net/lists/listinfo/sqlrelay-discussion