Slow reorder TreeBehaviour

I need my tree sorted by each post sort value. Here is the function
dealing with this. But it is executed extremely slow if some of the
parents has more than 20-30 children

function _sortPosts($newSort){
foreach ($newSort AS $id => $value) {
if(is_numeric($value['sort'])){
$this->Post->updateAll(array('Post.sort' => $value['sort']),
array('Post.id' => $id));
} else {
$this->Session->setFlash(__('Non-numeric value given.', true),
'default', array('class' => 'error'));
$this->redirect($this->referer());
}

}
foreach(array_keys($this->data['Post']) as $parent){
$this->Post->reorder(array('id' => $parent, 'field' =>
'Post.sort', 'order' => 'ASC', 'verify' => true));
}
}

Example:
38 posts, 8 parents and 30 children
5518 queries took 6028 ms
Page rendered in 20032ms.

Is there some other way to do this reorder without such a delay?

--
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