You might want to consider creating a finderQuery for this. (I'm definitely not the person to ask how to do that, btw)
Of course, you could also select without the HABTM, then use the Set class to grab your IDs and make a new query for the OrderLineItems. Then merge using Set again. Or something like that. Without seeing your setup, I can't be more specific than that. But it might be an improvement. On Fri, Jan 30, 2009 at 2:52 PM, Nate <[email protected]> wrote: > > There's probably a more optimal way to run the loop, but apparently > one's run into this particular issue before. Your options are (a) > file an optimization ticket and wait for someone to fix it, or (b) > file an optimization ticket with a patch ping a core developer (gwoo, > AD7six, Mark Story, me, etc.) to get it reviewed and committed, so no > one else has this problem. Ain't Open Source the greatest? > > On Jan 30, 11:47 am, Dan <[email protected]> wrote: >> No one has feedback on this? It seems like a MAJOR issue if you can't >> load more than a few thousand rows from "has many" relationship tables. > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
