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

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

jeremyburns@classoutfit.com
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 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

--
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