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