Re: Oracle or OCI8

Hi, I have already used Stored Procedure. When I use ORA_*, it just needs 1 sec. But it takes 10 sec. for OCI_*. Any suggestions? Thanks! Lung "Philippe Saladin" <psaladin@ville-dijon.fr> wrote in message news:20020718141409.49746.qmail@pb1.pair.com... > > I have tried both, it seems Oracle (i.e Ora_?) is much faster but OCI8 > is > > more powerful. So, how can I tune OCI8 in order to have faster response. > > ora_* functions are for Oracle 7 only. > oci_$ functions are for Oracle 7, Oracle 8 (and I suppose for Oracle 9). > So, for future compatibility, oci_* are IMHO the best choice. > What kind of faster response do you expect ? from a select, an update ? have > you tried stocked procedures ? > Regards, > Philippe > >