[Sqlrelay-discussion] RE : Oracle : Prefetch ?

[Sylvain G. <S.G...@fo...>]

=20
I have used the example code from the sourceforge documentation.
=20
The result is a "limit-like".
=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
If somebody has a good code for using buffer and prefetch with sql =
relay, could he show me ?
=20
Thanks.
=20
Regards
=20
=20
-----Message d'origine-----
De : sql...@li... =
[mailto:sql...@li...] De la part de =
Sylvain Gourvil=20
Envoy=E9 : mardi 10 octobre 2006 15:26
=C0 : sql...@li...
Objet : [Sqlrelay-discussion] Oracle : Prefetch ?
=20
=20
Hi everybody ?
=20
I am trying to put SQL Relay in a framework ans I need to deal with =
prefetch (Oracle).
I can not find any subject about it;
=20
Does SQL Relay deal with prefetch?
IF yes, could you help me?
=20
Thanks in advance.
=20
Regards.
=20