On Sep 21, 9:45 am, Grant Cox <[EMAIL PROTECTED]> wrote:
> Surely when he clicks the last page he's not requesting all 15K
> rows??! If so, that's some incredibly bad pagination! But then if
> the first 10 pages are consistently fast, and it's the later pages
> that are slow, it could be the terrible truth....
>
> Sounds like something from worsethanfailure.com though.
It's the nature of the beast ;).
I found this for info:
http://www.mysqlperformanceblog.com/2006/09/01/order-by-limit-performance-optimization/
Cheers,
AD
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
