On Oct 23, 7:43 pm, Miles J <[email protected]> wrote: > Im curious as how you think a join would be better? You are you going > to grab multiple comment rows for a single post, while paginating > posts? 2 queries is faster then sub-queries. > > More queries is sometimes better than complex queries.
Well, you may certainly be right, I never professed to be an SQL pro. Can you explain why two queries would be better in this case? I know this is not the best measurement, but looking at the query times Cake outputs in dev mode, they actually seem to be almost equal. Should I just stop worrying and love ActiveCake? On the other hand, two queries may be faster for MySQL, but the extra query will still add *some* network latency. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
