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

improve oracle dbc onnector performances: usage of offset

    XMLWordPrintable

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.

      Attachments

        Activity

          People

            unknown unknown
            72f8acac-185f-4a54-9470-a7473f50daab@accounts.ibexa.co Gaetano Giunta
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated: