If the field you're ordering by isn't indexed, then query performance
will be poor compared to SELECT * or ORDER BY id.
I strongly suggest you look into field indexing in your databases,
it's crucial for query performance.
On Apr 11, 9:30 am, crazyDavid <[EMAIL PROTECTED]> wrote:
> thanks a lot Rajesh! that worked! now i face another problem related
> to it. if i simply list, it works, but if i use 'order' in $paginate{
>
> }
>
> the same problem continues.....
>
> what am i doing wrong?
>
> On Apr 7, 10:25 pm, "R. Rajesh Jeba Anbiah"
>
> <[EMAIL PROTECTED]> wrote:
> > On Mar 17, 11:24 am,crazyDavid<[EMAIL PROTECTED]> wrote:
>
> > > I'm developing an application in cakephp 2.0 which needs to handle
> > > database with minimum of 100,000 rows of data. I'm using mysql
> > > database and apache (xampp). I'm facing a lot of problems during
> > > findAll() and paginate(), the script halts and is not executed
> > > completely. has someone been through a similar problem or someone
> > > knows the way around it, i'd be greatful to your suggestion and help.
> > > thanks in advance.
>
> > 1. Try restricting the associations: a. on the fly with unbind(), b.
> > with Bindable behavior
> > 2. http://groups.google.com/group/cake-php/browse_frm/thread/5f8ca538868...
>
> > --
> > <?php echo 'Just another PHP saint'; ?>
> > Email: rrjanbiah-at-Y!com Blog:http://rajeshanbiah.blogspot.com/
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
