Re: Fwd: Re: [PHP-DB] OCIFetch performance problem with more rows

2001-05-23 Thread snpe
On Wednesday 23 May 2001 13:13, Adi Wibowo wrote: > On Wed, 23 May 2001, Thies C. Arntzen wrote: > > > > > I have performance problem with OCIFetch (and OCIFetchInto, too) > > > > > when query return more rows.Same query from sqlplus is more fastest > > > > > (more rows is worse then less rows) >

Re: Fwd: Re: [PHP-DB] OCIFetch performance problem with more rows

2001-05-23 Thread snpe
On Wednesday 23 May 2001 12:21, you wrote: > > > > >Hello, > > > > > I have performance problem with OCIFetch (and OCIFetchInto, > > > > > too) when query return more rows.Same query from sqlplus is more > > > > > fastest (more rows is worse then less rows) > > > > > > > >Are the colum

Re: Fwd: Re: [PHP-DB] OCIFetch performance problem with more rows

2001-05-23 Thread Adi Wibowo
On Wed, 23 May 2001, Thies C. Arntzen wrote: > > > > I have performance problem with OCIFetch (and OCIFetchInto, too) > > > > when query return more rows.Same query from sqlplus is more fastest (more > > > > rows is worse then less rows) > > Indexes aren't problem.I use php and sqlplus with same

Re: Fwd: Re: [PHP-DB] OCIFetch performance problem with more rows

2001-05-23 Thread Thies C. Arntzen
On Wed, May 23, 2001 at 12:21:08PM +0200, Remigiusz Sokolowski wrote: > > > > >Hello, > > > > > I have performance problem with OCIFetch (and OCIFetchInto, too) > > > > > when query return more rows.Same query from sqlplus is more fastest (more > > > > > rows is worse then less rows) > > >

Re: Fwd: Re: [PHP-DB] OCIFetch performance problem with more rows

2001-05-23 Thread Remigiusz Sokolowski
> > > >Hello, > > > > I have performance problem with OCIFetch (and OCIFetchInto, too) > > > > when query return more rows.Same query from sqlplus is more fastest (more > > > > rows is worse then less rows) > > > > > >Are the columns you're fetching included in an Oracle index? Withou

Re: Fwd: Re: [PHP-DB] OCIFetch performance problem with more rows

2001-05-23 Thread Thies C. Arntzen
On Tue, May 22, 2001 at 09:03:45PM +0200, snpe wrote: > > > -- Forwarded Message -- > Subject: Re: [PHP-DB] OCIFetch performance problem with more rows > Date: Tue, 22 May 2001 21:02:42 +0200 > From: snpe <[EMAIL PROTECTED]> > To: "Brian S. Dunworth" <[EMAIL PROTECTED]> > > >