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

2011-05-31 Thread Tufla
Thank you very much Shaz, that was precisely what I did,and as I said, the reading process is now faster, but the written continues being a pain. On May 30, 3:11 pm, Shaz shazam...@gmail.com wrote: Index it! http://www.mainelydesign.com/blog/view/speeding-up-cakephp-acl-component On May 30,

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

2011-05-30 Thread Tufla
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

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

2011-05-30 Thread Shaz
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

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

2011-05-27 Thread Tufla
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

Saving ARO taking around 10 seconds, processing tree behavior.

2011-05-26 Thread Tufla
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(

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

2011-05-26 Thread Jeremy Burns | Class Outfit
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