DDC-2985: [GH-955] iteration risk note #3714

New Issue

admin · 2026-01-22T14:25:59+01:00

admin commented

2026-01-22 14:25:59 +01:00

Originally created by @doctrinebot on GitHub (Feb 17, 2014).

Originally assigned to: @beberlei on GitHub.

Jira issue originally created by user @doctrinebot:

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

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

Message:

instead of loading the whole result into memory at once

is not the full truth.

There is a certain risk of processes getting killed due to memory allocation with large iteration. This is caused by result buffering of the client. It is not always being visible to PHP as http://www.php.net/manual/en/mysqlinfo.concepts.buffering.php suggests.

This is only a proposal for discussion as I am not certain how to best add the information or if to add it at all (was it obvious before?). Is buffered iteration even a good suggestion for anything but small sets?

On a side-note: is there a way to run unbuffered queries with Doctrine?

Originally created by @doctrinebot on GitHub (Feb 17, 2014). Originally assigned to: @beberlei on GitHub. Jira issue originally created by user @doctrinebot: This issue is created automatically through a Github pull request on behalf of goatherd: Url: https://github.com/doctrine/doctrine2/pull/955 Message: > instead of loading the whole result into memory at once is not the full truth. There is a certain risk of processes getting killed due to memory allocation with large iteration. This is caused by result buffering of the client. It is not always being visible to PHP as http://www.php.net/manual/en/mysqlinfo.concepts.buffering.php suggests. This is only a proposal for discussion as I am not certain how to best add the information or if to add it at all (was it obvious before?). Is buffered iteration even a good suggestion for anything but small sets? On a side-note: is there a way to run unbuffered queries with Doctrine?

admin closed this issue

2026-01-22 14:26:00 +01:00

admin commented

2026-01-22 14:26:00 +01:00

@doctrinebot commented on GitHub (Mar 23, 2014):

Comment created by @doctrinebot:

A related Github Pull-Request [GH-955] was closed:
https://github.com/doctrine/doctrine2/pull/955

@doctrinebot commented on GitHub (Mar 23, 2014): Comment created by @doctrinebot: A related Github Pull-Request [GH-955] was closed: https://github.com/doctrine/doctrine2/pull/955

admin commented

2026-01-22 14:26:00 +01:00

@doctrinebot commented on GitHub (Mar 23, 2014):

Issue was closed with resolution "Fixed"

@doctrinebot commented on GitHub (Mar 23, 2014): Issue was closed with resolution "Fixed"

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#3714