topic Re: Data fetched from buffer or database in Application Development and Automation Discussions

Data fetched from buffer or database

Former Member — Wed, 23 Sep 2009 03:57:07 GMT

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

Re: Data fetched from buffer or database

nikhil_chitre — Wed, 23 Sep 2009 04:11:42 GMT

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

Re: Data fetched from buffer or database

Former Member — Wed, 23 Sep 2009 04:19:49 GMT

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..

Re: Data fetched from buffer or database

HermannGahm — Wed, 23 Sep 2009 06:36:49 GMT

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

Re: Data fetched from buffer or database

venkat_o — Wed, 23 Sep 2009 09:16:32 GMT

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.

Re: Data fetched from buffer or database

Former Member — Wed, 23 Sep 2009 11:54:08 GMT

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.