DDC-1706: aggregate all writes does not work #2148

New Issue

Closed

opened 2026-01-22 13:42:41 +01:00 by admin · 4 comments

admin commented 2026-01-22 13:42:41 +01:00

Owner

Copy Link

Originally created by @doctrinebot on GitHub (Mar 15, 2012).

Originally assigned to: @beberlei on GitHub.

Jira issue originally created by user jforet:

I have 1 entity :

namespace Test\DoctrineBundle\Entity;
use Doctrine\ORM\Mapping as ORM;

/****
 * Test\DoctrineBundle\Entity\User
 *
 * @ORM\Table(name="user")
 * @ORM\Entity
 */
class User
{
    /****
     * @ORM\Column(name="id", type="integer")
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    private $id;

    /****
     * @ORM\Column(name="name", type="string", length=255)
     */
    private $name;

...

In controller, i create 2 users, i persist and i flush

    public function indexAction()
    {
        $em = $this->getDoctrine()->getEntityManager();
        $repository = $em->getRepository('TestDoctrineBundle:User');

        $user = new User();
        $user->setName('name-'.rand(1, 1000));
        $em->persist($user);

        $user = new User();
        $user->setName('name-'.rand(1, 1000));
        $em->persist($user);

        $em->flush();
        return array();
    }

Results, i have 3 requests
[2012-03-15 08:23:53] doctrine.DEBUG: SET NAMES UTF8
[2012-03-15 08:23:53] doctrine.DEBUG: INSERT INTO user (name) VALUES (?) ({"1":"name-683"})
[2012-03-15 08:23:53] doctrine.DEBUG: INSERT INTO user (name) VALUES (?) ({"1":"name-638"})

I expect to have only 2 requests because i think "INSERT" lines have to be into one single transaction.

I am on dev environment, because in production, i can not know how many request i have.

Originally created by @doctrinebot on GitHub (Mar 15, 2012). Originally assigned to: @beberlei on GitHub. Jira issue originally created by user jforet: I have 1 entity : ``` namespace Test\DoctrineBundle\Entity; use Doctrine\ORM\Mapping as ORM; /**** * Test\DoctrineBundle\Entity\User * * @ORM\Table(name="user") * @ORM\Entity */ class User { /**** * @ORM\Column(name="id", type="integer") * @ORM\Id * @ORM\GeneratedValue(strategy="AUTO") */ private $id; /**** * @ORM\Column(name="name", type="string", length=255) */ private $name; ... ``` In controller, i create 2 users, i persist and i flush ``` public function indexAction() { $em = $this->getDoctrine()->getEntityManager(); $repository = $em->getRepository('TestDoctrineBundle:User'); $user = new User(); $user->setName('name-'.rand(1, 1000)); $em->persist($user); $user = new User(); $user->setName('name-'.rand(1, 1000)); $em->persist($user); $em->flush(); return array(); } ``` Results, i have 3 requests [2012-03-15 08:23:53] doctrine.DEBUG: SET NAMES UTF8 [2012-03-15 08:23:53] doctrine.DEBUG: INSERT INTO user (name) VALUES (?) ({"1":"name-683"}) [2012-03-15 08:23:53] doctrine.DEBUG: INSERT INTO user (name) VALUES (?) ({"1":"name-638"}) I expect to have only 2 requests because i think "INSERT" lines have to be into one single transaction. I am on dev environment, because in production, i can not know how many request i have.

admin added the Bug label 2026-01-22 13:42:41 +01:00

admin closed this issue 2026-01-22 13:42:41 +01:00

admin commented 2026-01-22 13:42:43 +01:00

Author

Owner

Copy Link

@doctrinebot commented on GitHub (Mar 15, 2012):

Comment created by @beberlei:

This has nothing to do with each other. You are just showing the log output. The Begin and Commit Statements are not listed in the log, the queries are still executed consequitevly, but they are aggregated in the transaction.

@doctrinebot commented on GitHub (Mar 15, 2012): Comment created by @beberlei: This has nothing to do with each other. You are just showing the log output. The Begin and Commit Statements are not listed in the log, the queries are still executed consequitevly, but they are aggregated in the transaction.

admin commented 2026-01-22 13:42:44 +01:00

Author

Owner

Copy Link

@doctrinebot commented on GitHub (Mar 15, 2012):

Comment created by jforet:

Thank you, Benjamin. Ok I understand what you say.
But I think it's too simple, or the tools provide incomplete information.

1st sample :

$user = new User();
$user->setName('name-1');
$em->persist($user);

$user = new User();
$user->setName('name-2');
$em->persist($user);

$em->flush();

$user = new User();
$user->setName('name-3');
$em->persist($user);

$em->flush();

$user = new User();
$user->setName('name-4');
$em->persist($user);

$em->flush();

The dev.log gives 4 queries ; the webprofiler bar in sf shows 4 queries.
[2012-03-15 11:50:01] doctrine.DEBUG: INSERT INTO user (name) VALUES (?) ({"1":"name-1"})
[2012-03-15 11:50:01] doctrine.DEBUG: INSERT INTO user (name) VALUES (?) ({"1":"name-2"})
[2012-03-15 11:50:01] doctrine.DEBUG: INSERT INTO user (name) VALUES (?) ({"1":"name-3"})
[2012-03-15 11:50:01] doctrine.DEBUG: INSERT INTO user (name) VALUES (?) ({"1":"name-4"})

2nd sample :

$user = new User();
$user->setName('name-1');
$em->persist($user);

$user = new User();
$user->setName('name-2');
$em->persist($user);

$user = new User();
$user->setName('name-3');
$em->persist($user);

$user = new User();
$user->setName('name-4');
$em->persist($user);

$em->flush();

The dev.log gives 4 queries ; the webprofiler bar in sf shows 4 queries.
[2012-03-15 11:51:31] doctrine.DEBUG: INSERT INTO user (name) VALUES (?) ({"1":"name-1"})
[2012-03-15 11:51:31] doctrine.DEBUG: INSERT INTO user (name) VALUES (?) ({"1":"name-2"})
[2012-03-15 11:51:31] doctrine.DEBUG: INSERT INTO user (name) VALUES (?) ({"1":"name-3"})
[2012-03-15 11:51:31] doctrine.DEBUG: INSERT INTO user (name) VALUES (?) ({"1":"name-4"})

In 1st sample, there is 3 transactions.
In 2nd sample, there is 1 transaction.

Is there a possibility to know number of transactions because i think it can help developpers in order to have better performances.

Maybe it is not in doctrine, it is in Symfony webprofiler; what do you think ?

@doctrinebot commented on GitHub (Mar 15, 2012): Comment created by jforet: Thank you, Benjamin. Ok I understand what you say. But I think it's too simple, or the tools provide incomplete information. **1st sample :** ``` $user = new User(); $user->setName('name-1'); $em->persist($user); $user = new User(); $user->setName('name-2'); $em->persist($user); $em->flush(); $user = new User(); $user->setName('name-3'); $em->persist($user); $em->flush(); $user = new User(); $user->setName('name-4'); $em->persist($user); $em->flush(); ``` The dev.log gives 4 queries ; the webprofiler bar in sf shows 4 queries. [2012-03-15 11:50:01] doctrine.DEBUG: INSERT INTO user (name) VALUES (?) ({"1":"name-1"}) [2012-03-15 11:50:01] doctrine.DEBUG: INSERT INTO user (name) VALUES (?) ({"1":"name-2"}) [2012-03-15 11:50:01] doctrine.DEBUG: INSERT INTO user (name) VALUES (?) ({"1":"name-3"}) [2012-03-15 11:50:01] doctrine.DEBUG: INSERT INTO user (name) VALUES (?) ({"1":"name-4"}) **2nd sample :** ``` $user = new User(); $user->setName('name-1'); $em->persist($user); $user = new User(); $user->setName('name-2'); $em->persist($user); $user = new User(); $user->setName('name-3'); $em->persist($user); $user = new User(); $user->setName('name-4'); $em->persist($user); $em->flush(); ``` The dev.log gives 4 queries ; the webprofiler bar in sf shows 4 queries. [2012-03-15 11:51:31] doctrine.DEBUG: INSERT INTO user (name) VALUES (?) ({"1":"name-1"}) [2012-03-15 11:51:31] doctrine.DEBUG: INSERT INTO user (name) VALUES (?) ({"1":"name-2"}) [2012-03-15 11:51:31] doctrine.DEBUG: INSERT INTO user (name) VALUES (?) ({"1":"name-3"}) [2012-03-15 11:51:31] doctrine.DEBUG: INSERT INTO user (name) VALUES (?) ({"1":"name-4"}) In 1st sample, there is 3 transactions. In 2nd sample, there is 1 transaction. Is there a possibility to know number of transactions because i think it can help developpers in order to have better performances. Maybe it is not in doctrine, it is in Symfony webprofiler; what do you think ?

admin commented 2026-01-22 13:42:46 +01:00

Author

Owner

Copy Link

@doctrinebot commented on GitHub (Mar 15, 2012):

Comment created by @beberlei:

Well the Symfony debug profiler only shows the queries, not the transactions. If you need the transactions you can extend it of course, for example listening to the "onFlush" event that marks the start of a UnitOfwork transaction. Its still not a bug and we won't add it to the core Doctrine bundle.

EntityManager#flush wrapping the transaction is discussed at length in the documentation.

@doctrinebot commented on GitHub (Mar 15, 2012): Comment created by @beberlei: Well the Symfony debug profiler only shows the queries, not the transactions. If you need the transactions you can extend it of course, for example listening to the "onFlush" event that marks the start of a UnitOfwork transaction. Its still not a bug and we won't add it to the core Doctrine bundle. EntityManager#flush wrapping the transaction is discussed at length in the documentation.

admin commented 2026-01-22 13:42:46 +01:00

Author

Owner

Copy Link

@doctrinebot commented on GitHub (Mar 15, 2012):

Issue was closed with resolution "Won't Fix"

@doctrinebot commented on GitHub (Mar 15, 2012): Issue was closed with resolution "Won't Fix"

Sign in to join this conversation.

No Branch/Tag Specified

Branches Tags

3.6.x

2.20.x

dependabot/github_actions/2.20.x/doctrine/dot-github/dot-github/workflows/composer-lint.yml-14.0.0

3.7.x

4.0.x

2.21.x

old-prototype-3.x

3.6.2

3.6.1

3.6.0

2.20.9

3.5.8

3.5.7

3.5.6

3.5.5

2.20.8

3.5.4

3.5.3

2.20.7

3.5.2

2.20.6

3.5.1

3.5.0

3.4.4

3.4.3

3.4.2

2.20.5

3.4.1

3.4.0

3.3.4

2.20.4

3.3.3

2.20.3

3.3.2

2.20.2

3.3.1

2.20.1

3.3.0

3.2.3

2.20.0

2.19.8

3.2.2

2.19.7

3.2.1

2.19.6

3.2.0

3.1.4

3.1.3

2.19.5

3.1.2

2.19.4

3.1.1

2.19.3

2.19.2

2.19.1

3.1.0

2.19.0

3.0.3

2.18.3

3.0.2

2.18.2

3.0.1

2.18.1

3.0.0

2.18.0

2.17.5

3.0.0-RC1

2.17.4

2.17.3

2.17.2

2.17.1

3.0.0-beta2

2.17.0

2.16.3

3.0.0-beta1

2.16.2

2.16.1

2.16.0

2.15.5

2.15.4

2.15.3

2.15.2

2.15.1

2.15.0

2.14.3

2.14.2

2.14.1

2.14.0

2.13.5

2.13.4

2.13.3

2.13.2

2.13.1

2.13.0

2.12.4

2.12.3

2.12.2

2.12.1

2.12.0

2.11.3

2.11.2

2.11.1

2.11.0

2.10.5

2.10.4

2.10.3

2.10.2

2.10.1

2.10.0

2.9.6

2.9.5

2.9.4

2.9.3

2.9.2

2.9.1

2.9.0

2.8.5

2.8.4

2.8.3

2.8.2

2.8.1

2.8.0

2.7.5

2.7.4

v2.7.3

v2.7.2

v2.7.1

v2.7.0

v2.6.6

v2.6.5

v2.6.4

v2.6.3

v2.6.2

v2.6.1

v2.6.0

v2.5.14

v2.5.13

v2.5.12

v2.5.11

v2.5.10

v2.5.9

v2.5.8

v2.5.7

v2.5.6

v2.5.5

v2.5.4

v2.5.3

v2.5.2

v2.4.8

v2.5.1

v2.5.0

v2.5.0-RC2

v2.5.0-RC1

v2.5.0-beta1

v2.5.0-alpha2

v2.5.0-alpha1

v2.4.7

v2.4.6

v2.4.5

v2.4.4

v2.4.3

v2.3.6

v2.4.2

2.3.5

v2.4.1

v2.4.0

2.4.0-RC2

2.4.0-RC1

2.4.0-BETA2

2.3.4

2.3.3

2.4.0-BETA1

2.3.2

2.3.1

2.3.0

2.3.0-RC4

2.3.0-RC3

2.3.0-RC2

2.2.3

2.3.0-RC1

2.3.0-BETA1

2.1.7

2.2.2

2.2.1

2.1.6

2.2.0

2.2.0-RC1

2.2.0-BETA2

2.2.0-BETA1

2.1.5

2.1.4

2.1.3

2.1.2

2.1.1

2.0.7

2.1.0

2.1.0RC3

2.1.0RC2

2.1.0RC1

2.0.6

2.1.0BETA1

2.0.5

2.0.4

2.0.3

2.0.2

2.0.1

2.0.0

2.0.0RC2

2.0.0RC1

2.0.0-BETA4

2.0.0-BETA3

2.0.0-BETA2

2.0.0-BETA1

Labels

Clear labels

BC Break

Bug

Can't Fix

Deprecation

Documentation

DQL

Duplicate

Failing Test

Hacktoberfest

Improvement

Improvement

Incomplete

Invalid

Missing Tests

New Feature

PR Created

pull-request

Mirrored from GitHub Pull Request

Question

Regression

Status: Waiting feedback

Waiting feedback

WIP

Won't Fix

No Label Bug

Milestone

No items

No Milestone

Projects

Clear projects

No project

Assignees

Clear assignees

admin

No Assignees

1 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#2148