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.organdhelp > > > others with their CakePHP related questions. > > > > To unsubscribe from this group, send email to > > > cake-php+unsubscr...@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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php