Wednesday, April 15, 2009

difference between stored prcedure and inline qery

sp: stored procedure execute at server side.. database server execute it..

inline : execute in application code..so it has overhead on application (may little slow ur application)

sp: it is pre- compile type command once we execute server creates a execution program for sp,
so when next time thay sp call it gives faster reply....

inline : there is no mechanism in inline so it does not have such feature.

No comments:

Post a Comment