topic Re: Buffering a Table View in Application Development and Automation Discussions

Buffering a Table View

kmoore007 — Thu, 10 Feb 2005 15:04:38 GMT

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.

Re: Buffering a Table View

Former Member — Thu, 10 Feb 2005 15:13:12 GMT

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.

Re: Buffering a Table View

kmoore007 — Thu, 10 Feb 2005 15:30:53 GMT

Can you create an index on a view?

Message was edited by: Kenneth Moore

Re: Buffering a Table View

Former Member — Thu, 10 Feb 2005 15:34:40 GMT

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.

Re: Buffering a Table View

Former Member — Thu, 10 Feb 2005 16:58:13 GMT

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