topic Re: Performance Problem with pooltable access in Application Development and Automation Discussions

Performance Problem with pooltable access

sinan_keklik — Tue, 22 May 2007 19:58:31 GMT

Hi,

pool tables are normally big Tables. I want to set limits, but it is not possible to use GROUP BY and so on.

Is there anyway to handle pooltables without loading the whole table in an internal table?

Sinan

Re: Performance Problem with pooltable access

Former Member — Tue, 22 May 2007 19:59:56 GMT

the WHERE clause of SQL is not going to help you?

Re: Performance Problem with pooltable access

Former Member — Tue, 22 May 2007 20:03:43 GMT

data: it_vbfa type table of vbfa.

data: Some_Number type vbfa-vbelv.

SELECT * from vbfa into table it_vbfa

WHERE VBELV = Some_NUMBER.

Re: Performance Problem with pooltable access

Former Member — Tue, 22 May 2007 20:10:36 GMT

A016 is a Pooled table.

REPORT ZR_SANDBOX_PROG3.

tables: A016.

data: it_A016 type table of A016.

data: r_A016 type A016.

data: u type i.

select * from a016 into table it_a016

where EVRTP = '000010'.

loop at it_a016 into r_a016.

u = u.

endloop.

In our system, A016 has 270 entries. The internal table above has 179 entries.

Has your issue been resolved with the WHERE clause?

Re: Performance Problem with pooltable access

Former Member — Wed, 23 May 2007 04:23:24 GMT

Hi,

U can use Where clause:

Rembember, to improve performance u should give more and more conditions on KEY fields.

e.g.

Select * from <p_table> into itab WHERE <fldname> = <condition>.

This will fetch only required entries passing <condition>.

Jogdand M B

Re: Performance Problem with pooltable access

sinan_keklik — Wed, 23 May 2007 06:27:46 GMT

I have the problem that I want to get all datasets from A018 with the same key (till ekorg) and in EKORG 0100 and 0200. In a normal Table I make:

SELECT key_1 key_2 COUNT( * ) FROM A018

INTO itab

WHERE ekorg = 0100

OR ekorg = 0200

GROUP BY key_1 key_2

HAVING COUNT( * ) > 1.

Any Ideas for pool tables?

Sinan