Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-18977

improve oracle dbc onnector performances: usage of offset

    Details

      Description

      Using the $ofset parameter the way it is currently done in arrayquery(), is not efficient: oracle will still fetch all rows starting from the first one, and drop the unwanted one on the client (see php man pages for oci_fetch_xxx for details).

      The correct way to implement offset is to wrap the SELECT call in another external select, filtering on ROWNUM - see the oracle php underground manual for details.

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            unknown
            Reporter:
            Gaetano Giunta
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: