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+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php