Skip to Content

Buffering a Table View

We are trying to boost the performance of a table join in a custom program. I created a table view to see if the performance was any better than coding the join in the program. It was not really any better. Then, I played around with the table buffering a bit. When I set the table buffering to Generic with 3 fields, the program ran over 50% faster. Is it a bad thing to turn on the buffer for a table view? The tables joined are MKPF and MSEG.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 10, 2005 at 03:13 PM

    Hi Kenneth,

    I don't know in what kind of company you are working, but the table you are referring to will normally be updated very regularly (material documents). In that case it doesn't make too much sense to turn on buffering as the buffer will be invalidated and refreshed very often.

    Perhaps creating a suitable index will be more efficient?

    Regards,

    John.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Kenneth Moore

      No you can't. What I ment was that your create suitable indices on the tables to have a better performance on the join in your program. But that depends on the selections you are using. If the join now runs over the primary keys it doesn't make any sense to create indices.

      Regards,

      John.

  • Posted on Feb 10, 2005 at 04:58 PM

    Hello,

    I am not sure whether Secondary Indexes BSID, BSAD, BSIK, BSAK, BSIK would help you.

    I am not sure of the Secondary Index w.r.t Material Movenents.

    Regards, Murugesh AS

    Message was edited by: Murugesh Arcot

    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.