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
Go To First  |  Previous Question  |  Next Question 
 PS Mixed  |  Question 193 of 200    Print  
What is the difference in using SQL directly and calling SQL from Peoplecode in Application Engine?

  
Total Answers and Comments: 1 Last Update: December 11, 2007     Asked by: priya 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
December 11, 2007 06:09:10   #1  
surender_engg Member Since: December 2007   Contribution: 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

 
Is this answer useful? Yes | No

 Related Questions

Latest Answer : peopelsoft appengine event is onExcute ...

Latest Answer : in addtion to the 8 listed above, there is an additionally action for AE programs that are marked as TRansform programs and the action is XSLT ...

Latest Answer : There Can be n number of Temporary tables, but App. engine. creates upto 99 instances for a single temporary table. ...

Latest Answer : SQL Statements are PLaform Dependent where as Meta-SQL statements are Platform Independent ...

Latest Answer : A record is basically a table in PeopleSoft. There are 7 types of records in PS.A record peoplecode is something that will run for all the components wherever this record is used (provided we have not used any wrapper to check the components). The people ...

Answered by Leah on 2005-05-09 12:39:03: AE are maintained with in PeopleSoft, with in Application Designer SQRs are a 3rd party software and not mainteinted with in PS, therefore need a separte upgrade 
Latest Answer : Application Engine is used for batch processing where you have a large (or small) amount of data that needs to be processed with out user intervention. we can develop Application Engine with in Application Designer.SQRs are a 3rd party software ...

Latest Answer : Save Edit people code performs once the user tries to save the component. It is used to validate data before it is updated on the database.Field Edit People code is performed after a field has changed and the new value of the field satisfies the standard ...

Answered by Leah on 2005-05-09 12:31:51: App Reviewer was the peoplecode debugger in PeopleTools 7.0 and 7.5, Debugger is the the Peoplecode Debugger used in 8.0 and above 
Latest Answer : App Reviewer was the peoplecode debugger in PeopleTools 7.0 and 7.5, Debugger is the the Peoplecode Debugger used in 8.0 and above ...

Latest Answer : Peoplcode trace can mean setting peoplecode trace for record peoplecode or for app engine(on execute).For getting the trace for peoplecode(record level), need to go to options and select various levels of trace by checking what level u wat( Stack, every ...

Latest Answer : A Chart of accounts is a list of all accounts tracked by a single accounting system, and should be designed to capture financial information to make good financial decisions. Each account in the chart is assigned Chartfields are the individual fields ...


 Sponsored Links

 
Related Articles

Application Development in .NET

ASP NET 2 0 Tutorials Application development in NET Client Side Application Development Client applications are applications that run on the client system or the desktop of the user They are closest to the traditional windows based applications and they display forms or windows on the desktop enabl
 

N-Tier Application Partitioning

N Tier Application Partitioning Application partitioning is a vital process as it provides one with the opportunity to clearly define an even distribution of an application s presentation process and key data components without which you may find yourself feeling quite lost The components may be dis
 

N-Tier Application Manageability

N Tier Application Manageability While it is a fact that N Tier applications tend to provide almost limitless scalability the desire to change or add new forms of functionality can present a challenge in more than one arena Growth on a large scale can make capacity planning quite hard When available
 

What is difference between call by value and call by reference in function?

The arguments passed to function can be of two types 1. Values passed 2. Address passed The first type refers to call by value and the second type refers to call by reference. For instance consider program1 main() { int x=50, y=70; interchange(x,y); printf(“x=%d y=%d”,x,
 

Application Frameworks in SQL Server 2005

The new application framework of SQL called the Service Broker is a distributed application framework that provides relable asynchronous messaging at the database to database level. It allows internal and external processes to exchange streams of reliable asynchronous messages using extensions of T-
 

Rapid Application Development

What is RAD? One of the conveniences of developing software is that it is not a physical tool that can be lost once it gets developed or manufactured. Codes are used to implement the software and it does not disappear together with the product. We can re-use the code all over again in another softw
 

The Interview Snafu

How to turn someone else’s mistake to your advantage Your dream job is about to become reality. A recruiter gave you the heads up about the perfect position at Humungous Conglomerate, Inc. You went through five interviews as well as a battery of psychological tests mandated by their HR de
 

Effective Controls for Attaining Continuous Application Security

Effective Controls for Attaining Continuous Application Security Throughout the Web Application Development Life Cycle Given the choice, every organization would want secure Web sites and applications from the Web application development phase all the way through the software development life cycle.
 

Winning a Job Interview with a Winning Resume

Does your resume unlock your potential, take your skills to the highest level and win you the interview and the job you want now? The job market today is highly competitive and even if you think you have what it takes to get an interview you won’t get over the line without a polished, prof
 

Web Application Vulnerability Assessment Essentials

Your First Step to a Highly Secure Web Site If an organization taking a systematic and proactive approach to web security, and to running a web application vulnerability assessment in particular, then that organization defended against the most rapidly increasing class of attacks. &nb
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape