PHPackages                             alexjumperman/doctrinetemptable - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. alexjumperman/doctrinetemptable

ActiveSymfony-bundle[Database & ORM](/categories/database)

alexjumperman/doctrinetemptable
===============================

Doctrine 2 temp table extension

1.0.1(7y ago)113PHPPHP >=5.5.9

Since Nov 11Pushed 7y agoCompare

[ Source](https://github.com/AlexJumperman/DoctrineTempTableExtension)[ Packagist](https://packagist.org/packages/alexjumperman/doctrinetemptable)[ RSS](/packages/alexjumperman-doctrinetemptable/feed)WikiDiscussions master Synced 2mo ago

READMEChangelogDependencies (2)Versions (3)Used By (0)

DoctrineTempTableExtension
==========================

[](#doctrinetemptableextension)

Problem
-------

[](#problem)

let's imagine that we have online-store with 1M products. On one specific category page we need to work only with 100 products from the whole stack, and we need to get:

1. total products count on this page
2. first 10 product entities sorting by some order
3. products count by every single filter etc.

Queries by the entire stack will not be effective. More efficient way - select needed products into temporary table and executing this queries from temporary table.

Install
-------

[](#install)

composer require alexjumperman/doctrinetemptable

Usage
-----

[](#usage)

### 1. Using repository trait

[](#1-using-repository-trait)

```