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

ez Oracle cluster backend performance tuning

    XMLWordPrintable

Details

    • Icon: Improvement Improvement
    • Resolution: Obsolete
    • Icon: Medium Medium
    • None
    • 3.9.3
    • None
    • Operating System:
      PHP Version: (please be specific, like '4.4.3' or '5.1.5')
      Database and version: oracle 10.2
      Browser (and version):

    Description

      A lot of unnecessary queries are executed by the clusterfilehandler backend driver for Oracle.

      The attached patched version tries to improve performance by:

      • switching connect to pconnect to avoid wasting time on a new oracle connection every time
      • removing every select count before doing a delete
      • removing every select count before doing a fetch - all that might be impacted are warning messages a little bit less explicative
      • do not fetching blob data out of the db when doing an object copy

      btw: is there an ini param that should dictate behaviour regarding connect vs. pconnect?

      Attachments

        1. oracle_php4_fast.php
          25 kB
        2. oracle_php5_fast.php
          26 kB
        3. oracle.php
          23 kB

        Activity

          People

            72f8acac-185f-4a54-9470-a7473f50daab@accounts.ibexa.co Gaetano Giunta
            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:
              Resolved: