Data fetched from buffer or database

[Former Member]

Hi,

How to check tin the select query the data is being fetched from buffer or database .Is there any method to trace that or it is just the setting we are doing while creating a table..

Pls suggest

[nikhil_chitre]

hello..

there is an extension for select statement if you do not want the data to be read from database table directly

... BYPASSING BUFFER

Effect

This addition causes the SELECT statement to avoid the SAP buffering and to read directly from the database and not from the buffer on the application server.

Regards,

Nikhil

[Former Member]

Hi Nikil,

tHAKS FOR REPLYING but You have not understood my question .I know to avoid buffer .But how to see in trace .. Pls read my question once again

Thanks in advance..

[HermannGahm]

Hi,

>

>Is there any method to trace that  or it is just the setting we are  doing while creating a table..
> Pls suggest

sure. ST05.

SQL Trace shows everything that is going to the database. This means those statements are NOT

using the buffer. The SQL Trace lines are yellow.

Buffer Trace shows everything that is going to the buffer. This means those statements are NOT

going to the database. The Buffer Trace lines are blue.

Kind regards,

Hermann

[venkat_o]

Hi Arun, <li>Go to SE11 ->Enter any standard table or table which you are using in SELECT query and Display->Click on Technical Settings button->You can see now there Buffering type . <li>If any of the check boxes for the buffer selected, the type of buffering is used in your program when SELECT query is used. Thanks Venkat.

[Former Member]

switching on the buffer does no guarantee that the buffer is used!

As said, the SQL-Trace - better name database trace - tells which SQL statement does not use the buffer.