Which is best Query builder vs Stored Procedure

Basically I always use stored procedure for everything even it is a single query. I want to know the Pros and Cons of both methods

In most cases you will not see a difference, the difference will lay in the query caching.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )