Skip to Content
author's profile photo Former Member
Former Member

Question about Buffer Access Time

Following sentences is description of Buffer Access Time of Dialog response time in ST03.

Buffer Access Time

Certainly, buffer access requires some time in the u03BCs/ms range, depending on the amount of requested data and the type of access. This time is not reported separately. Effectively, buffer access time is knocked down to processing time. In extreme cases, buffer accesses can even take seconds! Why is that? Data is buffered with a structure according to its primary index; the buffer does never contain indexes. Thus, accessing the buffered data other than by primary index may result in high buffer access time.

My questions are:

1. How to understand "Data is buffered with a structure according to its primary index"? When a table is fully buffered, all records are buffered. What else will be buffered?

2. If a table has a large data volume and it's fully buffered into memory, when application wants to query from the buffered table, what's the execution plan, only full table scan in memory?

Please advise. Thanks

James

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Dec 04, 2008 at 02:53 PM

    1. How to understand "Data is buffered with a structure according to its primary index"? When a table is fully buffered, all records are buffered. What else will be buffered?

    Nothing else.... just data

    2. If a table has a large data volume and it's fully buffered into memory, when application wants to query from the buffered table, what's the execution plan, only full table scan in memory?

    No... it looks at the index and the index send them to the buffered data.

    Regards

    Juan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.