Monday, May 30, 2011

Re: Saving ARO taking around 10 seconds, processing tree behavior.

Index it!

http://www.mainelydesign.com/blog/view/speeding-up-cakephp-acl-component

On May 30, 7:29 pm, Tufla <hocanaste...@gmail.com> 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 <hocanaste...@gmail.com> 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
>
> > <jeremybu...@classoutfit.com> 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
>
> > > jeremybu...@classoutfit.comhttp://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
> > > > cake-php+unsubscribe@googlegroups.com 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
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php

No comments: