Doctrine 2 - ORM
  1. Doctrine 2 - ORM
  2. DDC-2071

[GH-476] Replaced the setting of Ids to the whereInQuery with a more performant implementation

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.3.1
    • Component/s: None
    • Security Level: All
    • Labels:
      None

      Description

      This issue is created automatically through a Github pull request on behalf of HarmenM:

      Url: https://github.com/doctrine/doctrine2/pull/476

      Message:

      While working with large datasets in combination with pagination (ie. a pagination window of 100 or more), the performance drastically decreased.

      I tracked the problem down to the setting of the parameters. In the old implementation, the parameters are set individually. This pull request sets the parameter as an array to the Query and Walker.

      Testing results (# of entities, original performance, improved performance):
      32 0,036 0,033
      64 0,043 0,037
      128 0,065 0,043
      256 0,133 0,057
      512 0,360 0,088
      1024 1,212 0,157
      2048 4,462 0,332
      4096 17,203 0,818

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Benjamin Eberlei
            Reporter:
            Benjamin Eberlei
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: