#1586: Caching subqueries
-----------------------------------+----------------------------------------
Reporter: colnector | Owner: romanb
Type: enhancement | Status: new
Priority: major | Milestone: Unknown
Component: Query/Hydration | Version: 1.1-DEV
Keywords: | Has_test: 0
Mystatus: Pending Core Response | Has_patch: 0
-----------------------------------+----------------------------------------
Sometimes a query contains expensive sub-queries. Having the ability to
cache these sub-queries may provide a great performance enhancement.
Example:
SELECT a.x, a.y FROM ClassA a WHERE a.id IN (..expensive subquery..) AND
a.x > 8 AND a.y > 999
SELECT a.x, a.y FROM ClassA a WHERE a.id IN (..expensive subquery..) AND
a.x > 5 AND a.y > 11
To facilitate such a thing now I'll have to launch the sub-query myself
and cache its results for use in the new query. It would be good if this
process could be automated.
Also, it would be helpful if sub-queries could be specified with
Doctrine_Query instead of DQL.
--
Ticket URL: <http://trac.doctrine-project.org/ticket/1586>
Doctrine <http://www.phpdoctrine.org>
PHP Doctrine Object Relational Mapper
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"doctrine-svn" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.co.uk/group/doctrine-svn?hl=en-GB
-~----------~----~----~----~------~----~------~--~---
