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.organd help > > others 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
