What about building this query in pure sql ?
----- Message d'origine ----
De : "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
À : symfony users <[email protected]>
Envoyé le : Vendredi, 4 Janvier 2008, 11h53mn 08s
Objet : [symfony-users] Propel performance
hi all, I need help to to this in one request in order to perform the
code :
This is the actual requests :
$c = new Criteria();
$c->add(ActActEntityNrefPeer::ENT_ENTITY_ID, $beneficiaire_id);
$c->add(ActActEntityNrefPeer::ACT_TYPE_PARTICIPATION_ID, 4);
$c->addJoin(ActActEntityNrefPeer::ACT_ACT_ID,ActActPeer::ID,
Criteria::LEFT_JOIN);
$c->add(ActActPeer::START_DATETIME, date('Y-d-m
H:i',mktime(0,0,0,date("n"),date("j")-$ago,date("Y"))),
Criteria::GREATER_THAN);
$c->addSelectColumn(ActActEntityNrefPeer::ACT_ACT_ID);
$actes = ActActEntityNrefPeer::doSelectRS($c);
while($actes->next()){
$c2=new Criteria();
$c2->add(ActActEntityNrefPeer::ACT_ACT_ID,
$actes->getInt(1));
$c2->add(ActActEntityNrefPeer::ACT_TYPE_PARTICIPATION_ID,
5);
$c2->addOr(ActActEntityNrefPeer::ACT_TYPE_PARTICIPATION_ID,
6);
$c2->addOr(ActActEntityNrefPeer::ACT_TYPE_PARTICIPATION_ID,
7);
$c2->addSelectColumn(ActActEntityNrefPeer::ENT_ENTITY_ID);
$res = ActActEntityNrefPeer::doSelectRS($c2);
while($res->next()){
isset($liste[$res->getInt(1)]) ?
$liste[$res->getInt(1)]++ :
$liste[$res->getInt(1)]=1;
}
}
The first request result contains average 200 elements. That is why I
need to combine 2 requests in one.
Thanks , Julien.
_____________________________________________________________________________
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
http://mail.yahoo.fr
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" 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.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
