PHP Oracle 8 Functions Efficiency Problem
| From: | notoriousvic_ca | Date: | Thu, 27 Jun 2002 17:09:23 +0000 |
| Subject: | PHP Oracle 8 Functions Efficiency Problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-104189@lists.php.net to get a copy of this message | ||
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?
2) Has anyone tried to save a cursor or connection into a session?
Thanks in advance