#1615: Doctrine_Pager is highly inefficient
------------------------+---------------------------------------------------
Reporter: colnector | Owner: guilhermeblanco
Type: task | Status: new
Priority: major | Milestone: Unknown
Component: Pager | Version: 1.0.3
Resolution: | Keywords:
Has_test: 0 | Mystatus: Pending Core Response
Has_patch: 0 |
------------------------+---------------------------------------------------
Changes (by colnector):
* mystatus: Pending User Response => Pending Core Response
Comment:
Thank you for your comment.
If this is a case of wrong or inadequate usage of the pager component by
myself, I guess there should be some extra description about the way the
pager works in the manual. Here's an example of queries generated by
something very common:
{{{
1. SELECT COUNT(DISTINCT u.id) AS num_results FROM user u INNER JOIN
sf_guard_user s ON u.id = s.id AND s.is_active = 1 WHERE
u.last_inventory_update > ? GROUP BY u.id - (2008-07-29T08:45:58+03:00 )
2. SELECT u.id AS u__id, u.first_name AS u__first_name, u.last_name AS
u__last_name, u.last_inventory_update AS u__last_inventory_update, s.id AS
s__id, s.username AS s__username, s.algorithm AS s__algorithm, s.salt AS
s__salt, s.password AS s__password, s.is_active AS s__is_active,
s.is_super_admin AS s__is_super_admin, s.last_login AS s__last_login,
s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM user u
INNER JOIN sf_guard_user s ON u.id = s.id AND s.is_active = 1 WHERE
u.last_inventory_update > ? ORDER BY s.username ASC LIMIT 40 -
(2008-07-29T08:45:58+03:00 )
3. SELECT u.id AS u__id, u.first_name AS u__first_name, u.last_name AS
u__last_name, u.last_inventory_update AS u__last_inventory_update, s.id AS
s__id, s.username AS s__username, s.algorithm AS s__algorithm, s.salt AS
s__salt, s.password AS s__password, s.is_active AS s__is_active,
s.is_super_admin AS s__is_super_admin, s.last_login AS s__last_login,
s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM user u
INNER JOIN sf_guard_user s ON u.id = s.id AND s.is_active = 1 WHERE
u.last_inventory_update > ? ORDER BY s.username ASC LIMIT 40 -
(2008-07-29T08:45:58+03:00 )
}}}
sfGuardUser you should know and User is a user profile class. They are
related with the `id` key.
--
Ticket URL: <http://trac.doctrine-project.org/ticket/1615#comment:6>
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
-~----------~----~----~----~------~----~------~--~---
