GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Peoplesoft  >  PS Mixed

 Print  |  
Question:  What is the difference in using SQL directly and calling SQL from Peoplecode in Application Engine?



December 12, 2007 06:09:10 #1
 surender_engg   Member Since: December 2007    Total Comments: 5 

RE: What is the difference in using SQL directly and calling SQL from Peoplecode in Application Engine?
 
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
     

 

Back To Question