Index it! http://www.mainelydesign.com/blog/view/speeding-up-cakephp-acl-component
On May 30, 7:29 pm, Tufla <[email protected]> wrote: > After apply the change, the reading process has been improved a > little, but the writing process continue taking a lot time :S BTW I > checked and the AROS table is not fragmented. Any other idea ? Thank > you. > > On May 27, 12:29 pm, Tufla <[email protected]> wrote: > > > > > > > > > Wow Jeremy, thank you very much...very good suggestion, I will do it, > > and I'll let you know how it works. > > > On May 26, 11:54 pm, Jeremy Burns | Class Outfit > > > <[email protected]> wrote: > > > The standard SQL that creates these tables uses MyIsam and therefore does > > > not include referential integrity. Ideally, the tables should be InnoDb > > > and have proper referential integrity. If you don't have that and can do > > > it, I'd strongly recommend it. It will bring about dramatic speed > > > improvements. > > > > Jeremy Burns > > > Class Outfit > > > > [email protected]http://www.classoutfit.com > > > > On 26 May 2011, at 19:07, Tufla wrote: > > > > > I have an app working in CakePHP 1.2.1.8004 > > > > > Currently my ARO's table has up to 43000 rows, and the ARO's save > > > > process, every time that a user creates an account, has became really > > > > slow. It is taking around 10 seconds exactly in the point where the > > > > save is made: > > > > > $aro->save(array( > > > > 'model'=>$model, > > > > 'foreign_key'=>$id, > > > > 'parent_id'=>$parent_id, > > > > 'alias'=>$alias) > > > > ); > > > > > More in deeply, the most time is spent processing the tree behavior in > > > > the _setParent(...) method. > > > > > What can I do to improve the process performance ? Could it be an > > > > issue in the table ? > > > > > Thank you in advanced for your help. > > > > > -- > > > > Our newest site for the community: CakePHP Video > > > > Tutorialshttp://tv.cakephp.org > > > > Check out the new CakePHP Questions > > > > sitehttp://ask.cakephp.organdhelpothers with their CakePHP related > > > > questions. > > > > > To unsubscribe from this group, send email to > > > > [email protected] For more options, visit this > > > > group athttp://groups.google.com/group/cake-php -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
