Part of Content :
I often find ABAP developers struggling to optimize their programs in order to meet their users’ performance requirements. An ABAP program can be slow for a variety of reasons, but one of the most common is the presence of long-running SQL statements, which affects a program’s overall runtime. So what causes “expensive” SQL statements? What are the basic techniques for optimizing database access processing? What are the available utilities in an SAP R/3 system for achieving more streamlined and efficient data access? This article answers these questions by providing an overview of database access optimization for ABAP developers who have practical experience in database programming. Application programs can address this database by means of a standardized language known as SQL (Structured Query Language), which contains statements for reading, modifying, creating, and administering database tables. Open SQL statements do not access the database directly. They are checked at compile time and converted to the proper SQL statements for the specific database system. SQL and the SAP Architecture. SAP R/3 is based on a multi-tiered architecture. It consists of three layers: • The presentation layer • The application layer • The database server layer. Optimize the Size of the Result Set. Optimize the Amount of Data Transferred. Optimize the Number of Data Transfers. Optimize the Cost of Database Searches. Optimize the Load on the Database. As mentioned earlier, there may be many presentation or application servers, but there is just one database server in a single R/3 installation.
Tags : sap architecture, structured query language, optimizing database, sap r 3, abap programming, programming application, application servers, presentation layer, database searches, sql statements, application programs, database tables, database access, performance requirements, database programming
If you see unrelated pdf files with the description or copyrighted material published, please report to us, we'll correct/delete it it as soon as possible.NONE OF THOSE MATERIALS ARE HOSTED IN THIS SERVER NOR UPLOADED BY ME IN SOMEONE'S SERVERS. Read our DISCLAIMER for more detail.
We are neither affiliated with authors and brands nor responsible for its content and change of content.
Information contained herein is provided "as is" without warranty of any kind, either expressed or implied, including any warranty of merchantability or fitness for a particular purpose. In no event shall ANYONE be held liable for any loss of profit, special, incidental, consequential, or other similar claims.