BUFFER

[Former Member]

HI

A table is buffered. By select statement i dont want to get the data from table buffer. i want to get the data from database. how?

THANK YOU

ASHOK KUMAR

[Former Member]

Hi

see the concept of Buffering

We have 3 types of buffering

There are the following types of buffering:

o single-record buffering

o generic area buffering

o full buffering

Single-record buffering should be selected when :

o For large tables where there are frequent single-record accesses (using SELECT SINGLE ...). The size of the records being accessed should be between 100-200 KB.

o For comparatively small tables for which the access range is large, it is normally advisable to opt for full buffering. Only one database access is required to load such a table for full buffering,

while single-record buffering calls for a very large number of table accesses.

And also check this matter.

Single-record buffering: Only the records of a table that are really accessed are loaded into the buffer

Single-record buffering should be used particularly for large tables where only a few records are accessed with SELECT SINGLE. The size of the records being accessed should be between 100 and 200 KB.

Full buffering is usually more suitable for smaller tables that are accessed frequently. This is because only one database access is necessary to load such a table with full buffering, whereas several database accesses are necessary for single-record buffering.

Check this link :

http://help.sap.com/saphelp_nw04/helpdata/en/f7/e4c5a8a84a11d194eb00a0c929b3c3/content.htm

Reward points for useful Answers

Regards

Anji

[Former Member]

Hi,

Use this

select <field> from <table> bypassing buffer.

Regards,

Ameet

[Former Member]

You can use the addition BYPASSING BUFFER in the from clause of the select statement.

See the help on FROM command for more info...

Regards

Arun