Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Selecting from FMIOI - performance question

Former Member
0 Kudos

When I select from FMIOI using one fund (FONDS) and one fund center (FISTL) (let's call it fund center 1), I get results very quickly (within seconds). If I use the same fund and a different fund center (let's call it fund center 2), I still get results back quickly. But if I use the same fund as above and both fund centers 1 and 2 as selection criteria, it takes a long time to get results back. I see this behavior in both my custom program and when using SE16. Can anyone explain why selecting from FMIOI with two fund centers causes such a performance problem when individually the fund centers return with no problem?

1 ACCEPTED SOLUTION

KKilhavn
Active Contributor
0 Kudos

I can't prove it, but my best guess is that the database optimizer gets confused. And unfortunately it doesn't take much either as you have seen yourself. I have seen the same behaviour with other tables, where selection_time(1) + selection_time(2) << selection_time(1+2).

The database could perform one selection, then the next one, take a coffee break, and still return results much quicker than it does when selecting for both criteria.

Kjetil Kilhavn (Vettug AS) - ABAP developer since Feb 2000
1 REPLY 1

KKilhavn
Active Contributor
0 Kudos

I can't prove it, but my best guess is that the database optimizer gets confused. And unfortunately it doesn't take much either as you have seen yourself. I have seen the same behaviour with other tables, where selection_time(1) + selection_time(2) << selection_time(1+2).

The database could perform one selection, then the next one, take a coffee break, and still return results much quicker than it does when selecting for both criteria.

Kjetil Kilhavn (Vettug AS) - ABAP developer since Feb 2000