topic Re: select query taking long time to execute during background execution. in Application Development and Automation Discussions

select query taking long time to execute during background execution.

mukeshponraj1234 — Tue, 07 Dec 2021 07:18:49 GMT

Hi all,

We are facing an issue while running a background job select query is used to process entry from one ztable.

but it takes longer than usual, due to which this job goes in long running.

Any possible reasons of table being locked or any other reasons for query to process for such a long duration?

SELECT zcolumns
FROM ztables UP TO 1 ROWS
INTO lwa_table
WHERE zfield1 EQ primary_key_1
AND zfield2 EQ primary_key_2
ORDER BY key_field.

Re: select query taking long time to execute during background execution.

Sandra_Rossi — Tue, 07 Dec 2021 08:24:44 GMT

It's impossible to do a remote analysis with so few details. You should use the tools for performance analysis, like the ones which are provided with your database system, or at SAP level (ST03, ST04, ST12, SAT, etc.)

Re: select query taking long time to execute during background execution.

mukeshponraj1234 — Tue, 07 Dec 2021 08:33:50 GMT

Hi Sandra,

We took performance trace for the following job and at the same time there is another background job which is deleting the entries of same table, not sure due to this it is causing delay in fetching from select query.

there is no issue in select query, it fetches the entries quickly while processed in foreground.

when select query can take max time for fetching while doing any operation in the same table?

Re: select query taking long time to execute during background execution.

ponrajasekharan — Fri, 28 Jan 2022 03:27:42 GMT

The table modify state won't last long ..so your query should have feteched either latest modified or previous one .

Run SAT .. you find exactly where it takes more time.