Re: Looking to improve DB_DataObject performance for loops
| From: | Alan Knowles | Date: | Tue, 02 Nov 2004 02:13:05 +0000 |
| Subject: | Re: Looking to improve DB_DataObject performance for loops | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-15287@lists.php.net to get a copy of this message | ||
although It's know that 'new' is slower than cloning, I doubt this is significant enough for you to notice.. - you probably need to reduce the calls to the database.. (or cache the results somewhere.)
why not do:
$member->whereAdd('member_id in (1,2,3,4,5,6,7)');
$member->find();
while ($member->fetch()) {
$c = clone($member);
$c->doSomethingToMember();
}
Regards
Alan
Mike Zornek wrote:
I have a bit of code like:
$member_id_list = array(1,2,3,4,5,6,7);
foreach($member_id_list as $member_id) {
$member = new DataObjects_Member();
$member->get($member_id);
$member->doSomethingToMember();
$member = null;
}
Now it's taking way longer that I need it to. Any suggestions on how I might
speed this up?
~ Mike