On Jan 16, 4:57 pm, Miles J <[email protected]> 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 [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 -~----------~----~----~----~------~----~------~--~---
