Re: Looking to improve DB_DataObject performance for loops

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

Assuming your "doSomethingToMember()" method calls an update, don't do the select (->get), just set the id. Having 1 query per loop will be faster than 2.