Doctrine Optimize ManyToMany Queries
I got the following Entities:
- A User Entity, it has OneToMany Products and OneToMany Images
- A Product Entity that has ManyToMany Images
- An Image Entity, having the ManyToOne to User, and the (inverted) ManyToMany Products
The Images connected to the Product are also always connected to the same User Entity too.
I want to display for the Current User the Products and their Images in a Table.
- For this, the User is loaded by the User Provider. (1 Query)
- Then it gets the N Products for the User (1 Query)
- Then it ask Images joined by the ManyToMany table which Images are connected to the Products (N Queries)
The Last Queries I want to optimize somehow if able. My thought because I already know what kind of Images there will be because of the User OneToMany Relationship.
What could I do it make it better? Try to build my own Query? My own Hydrator? Maybe Caching of the Images Entities will be enough?
I tried making the Entities and their relationships Cacheable but that doesn't seems to reduce the amount of queries.
From what you explain:
You need to load from both user side (product and image). It can happen to load image not linked to the user (and product not linked to the user).
Your problem com from the many to many between product and image, that will force you to load image from product and not from user.
The solution would be to change your database to match this:
where the linked table containing all 3 foreign key has a uniq constraint on all 3. This way, you just have to load everything in 1 query from user if you use DQL or SQL.
- Zend Framework 1.11 + Doctrine 2 + Class Inheritance mapping (YAML) problems with generate entities
- How do I get the object id of an entity during the postRemove event?
- Cross Join to DQL
- Foreign Key Constraints does not work with Doctrine/Symfony and SQLite
- How can I implement a dotrine entity event listener
- Symfony 4.4 metadata_cache_driver configuration key deprecation notice
- i'm having trouble creating the database using symfony framework
- How to check if a class is a Doctrine entity?
- Many to many relation with ON DELETE CASCADE with Symfony and Doctrine
- Symfony 7.1 - Doctrine 2.13 automapping feature deprecation
- Doctrine 2 category_id always NULL when set ManyToOne relationship
- "The method "isEnabled" in class "App\Entity\Brand" requires 0 arguments, but should accept only 1"
- Generate query on doctrine querybuilder
- CodeIgniter Models vs Symfony/Doctrine Models
- Doctrine Using short namespace alias "App:MyEntity" Problem: Feature deprecated in doctrine/persistence 2.x and is not supported by persistence:3.x
- Gedmo\Loggable logs data that doesn't have changed
- DoctrineMongoDBBundle getting a fatal error in Symfony2
- How to use Repository custom functions in a FormType
- Doctrine- Group by date
- Binding entities to query parameters only allowed for entities that have an identifier
- Doctrine Relations, Breaking ManyToMany when I clone an entity
- Getting error while using interval in doctrine
- Automatically set database ID in CollectionType
- The form's view data is expected to be an instance of MyEntity but is an instance of ArrayCollection
- How to have a model Manager in Symfony2?
- Multiple Query in Doctrine with NAND,NOR,NOT,AND Operators
- Doctrine - Add default time stamp to entity like NOW()
- Index hinting in Doctrine2
- Zend Framework 2 Doctrine 2 many to many entity relation issue
- Listener "SoftDeleteableListener" was not added to the EventManager