What is the difference in using SQL directly and calling SQL from Peoplecode in Application Engine?

Interview Candidate
Sep 18th, 2007
3
3243

First
Prev
Next
Last

Showing Answers 1 - 3 of 3 Answers

surender_engg
Profile Answers by surender_engg

Dec 11th, 2007

Hey Priya,

If you use SQL directly then it will go to database directly to fetch rows of data. But if u write SQL'S in peoplecode, den the trip will be from application server to database because peoplecode resides in app server.

One should avoid writing SQL'S in App engine peoplecode as it would degrade the performance.

Regards
Surender