The exponential number would happen if your join isn't right. Are you saying that it's fetching 8 million rows, or that you think there's a looping bug in the code?
On Jan 19, 7:48 am, Dan <grip...@gmail.com> wrote: > On Jan 16, 4:57 pm, Miles J <mileswjohn...@gmail.com> wrote: > > > Why do you even need to grab 2800? > > I need to load them to generate order statistics. Another reason would > be for a CSV export. 2800 is very small. We're in the process of > developing an app that could have hundreds of thousands of rows in > multiple tables with a has many relationship. > > > Also whats the speed like for a low amount of results. And what > > happens when you limit what fields are returned. > > I'm already limiting the fields to exactly what I need. I just > simplified it for this post. > > I did some additional testing and it seems to loop (Order rows)^ > (OrderLineItem rows) times! That's almost 8 million loops to process > 2800 rows of data. It seems to loop through every Order row for every > OrderLineItem row. Anyone know why it would do this? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---