Call Stored Procedured CakePhp 2.x

Hi,
Actually I can execute a stored procedure SqlServer like this:

$this->ControllerName->query(‘dbo.sp_MyProcedure ‘.$id.’’);

It’s ok and function, but when the Procedure spend more time, it’s wrong.

The stored procedure make a lot of calculus and depends the number oof rows.
Thanks,