Can u pls paste those queries here so that v can check if they need some fine tuning or u can check if ur tables r indexed properly.

All this while I was under the impression that stored procedures run faster cuz they r pre compiled. Correct me if I'm wrong.