Re: PHP Oracle 8 Functions Efficiency Problem
| From: | Thies C. Arntzen | Date: | Sat, 29 Jun 2002 13:32:58 +0000 |
| Subject: | Re: PHP Oracle 8 Functions Efficiency Problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-104483@lists.php.net to get a copy of this message | ||
On Thu, Jun 27, 2002 at 11:09:23AM -0600, notoriousvic_ca wrote:
> I have an HTML form which allows users to query data in an Oracle 8
> Database. Usualy a search may return over 100 records so I diplay 10
> records per page. I would like to make the search more efficient by
> using the OCISetPrefetch to prefetch the first 10 records. This works
> great for the first page but for a page that displays records 90 to 100,
> I have to prefetch 100 records. I have two questions
> 1) Is there any way of fetching or Prefetching only say rows 80 to 90
> of a result set?
no - at some point the oci interface _will_ support
scrollable cursors (>= 9i only i think). that would allow you
to skip records.
> 2) Has anyone tried to save a cursor or connection into a session?
will not work.
tc