on 02-08-2021 3:26 PM
Hi Everyone,
I've got the following problem :
On a production system, a program is slowed down a lot (25% more).
The only change we did in the program is adding a field in a selection.
How will the buffer behave after this kind of change ?
I know that in ST04, we will find a new SQL-ID for the new query. but what will it do with the buffer, will it start again to put database data in buffer hence slowing down the query ?
My query is a join between two huge tables (almost 500M entries each)
Maybe the use of "for all entries" instruction doesn't help ?
Hi Everyone,
nobody encountered this kind of problem ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.