WHAT IS TABLE BUFFERING AND ADVANTAGE?
Answers were Sorted based on User's Feedback
Answer / sudhakar1207
TABLE BUFFERING IS USED TO IMPROVE PERFORMANCE OF OPEN SQL STATEMENTS.
TABLE BUFFERING IS NOTHING BUT STORING THE CONTENTS OF THE DB TABLES IN THE APPLICATION SERVER BUFFER.
BUFFERING IS OF THREE TYPES.
1) SINGLE RECORD BUFFERING
2) GENERIC BUFFERING
3) FULL BUFFERING
Is This Answer Correct ? | 14 Yes | 1 No |
Answer / prasath
buffering a table is allocating memory local to the
application server. by using this the application program
quickly access the data
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / manas
the frequently retrieved data from the database can be
stored in in application server as as buffer data, so it
will not hit the database to get the the data. so the
execution of the program will be fast. these data can be
defined as buffered data of table while creating a table.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / shreeshaildiggi
SAP buffering :
Buffering of data from database tables defined in a table
buffer in the shared memory of the current application
server. The definition determines whether and how a
database table is buffered. Buffering generally leads to
greatly enhanced performance (by a factor of between 50 and
500) and is administrated by the database interface.
Buffering usually becomes effective when Open SQL commands
are used for database access. However, some variants do not
use the buffering process.
The following Open SQL statements implicitly bypass the SAP
buffer and access the database tables directly:
SELECT with the addition FOR UPDATE,
Access to a table using single-record buffering without
selecting a single record using SINGLE SELECT or by
specifying the primary key in the WHERE condition (this
behavior depends on the current implementation of the
database interface and may be different in future
releases).
SELECT with the addition DISTINCT,
SELECT with aggregate expressions,
Open SQL statement with the addition CLIENT SPECIFIED,
without specification of the client ID in a WHERE
condition,
SELECT with JOIN expressions
Access to a generically buffered area without full
specification in a WHERE condition
Open SQL statements with IS [NOT] NULL in the additions
WHERE and HAVING,
Use of a subquery in a WHERE condition,
SELECT with the addition GROUP BY,
SELECT with the addition ORDER BY, whereby the sort key is
not the primary key.
Thanks and Regards
SHREESHAIL DIGGI
SAP Technical Consultant Infinite India
Is This Answer Correct ? | 2 Yes | 0 No |
differences between the sorted ,standard, hashed tables.
****THANK YOU ALL ABAP EXPERTS**** I got a JOB as ABAP Consultant in Infosys.I cleared the interview.The question posted here are really good.I cleared interview based on this material only.It really works.I thank all members who posted que&ans here. Those who are in search of job in MNC study this question set only you will get sucess. Thanks once again allinterview.com and members of this community. tulika20021@rediffmail.com
0 Answers AC Tech, Accenture, IBM,
When i create a Table Maintenance Generator ,which is the event that will Trigger ?
what is a binary search ? and how it is useful in a sorted internal table?
Events that can be used in both the classical and interactive reports
Can Top-of-page trigger with VLINE.?
What is the lock object?
What is the difference between open_form and close_form?
EXPLAIN ABOUT RANGES ?
What are two different ways to add fields to sap tables?
What is the reason, a BDC program is working in 'A' mode but not in 'N' mode ?
What do you mean by batch data communications programming?