Re: Saving ARO taking around 10 seconds, processing tree behavior.
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, 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 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.organdhelpotherswith 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
Re: Saving ARO taking around 10 seconds, processing tree behavior.
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
Re: Saving ARO taking around 10 seconds, processing tree behavior.
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 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.organdhelpothers 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
Re: Saving ARO taking around 10 seconds, processing tree behavior.
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.organd 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 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
Saving ARO taking around 10 seconds, processing tree behavior.
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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
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 jeremybu...@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+unsubscr...@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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php