Re: Re: Looking to improve DB_DataObject performance for loops

On 11/1/04 5:36 PM, "Andrew Nagy" <asnagy@webitecture.org> wrote: > 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. The doSomethingToMember() requires data that is gotten via the SELECT so it would be tough to get rid of. Thanks for the suggestion though. ~ Mike ----- Mike Zornek Web Designer, Media Developer, Programmer and Geek Personal site: <http://MikeZornek.com>