topic Performance Issue : MODIFY Z-table from internal table in Application Development and Automation Discussions

Performance Issue : MODIFY Z-table from internal table

sanjana_lingras — Fri, 03 Sep 2021 09:24:06 GMT

Hi,

I am facing performance issue while modifying 3 custom tables from internal table. Internal table is having 400 records.

All the three custom tables are column store and buffering not allowed in technical settings.

While modifying 400 records from internal table to custom table , program is giving timeout error.

As per ST05 trace MODIFY statement is taking long time to execute.

syntax : MODIFY ztable FROM TABLE it_tab. (it_tab is having 400 records)

Any other modification can be done to code to avoid this issue?

Thanks.

Re: Performance Issue : MODIFY Z-table from internal table

RaymondGiuseppi — Fri, 03 Sep 2021 09:38:47 GMT

Processing 400 records should be almost instantaneous, did you already

perform some trace (sql ST05 or abap SAT)?
consider replacing MODIFY with SELECT and then INSERT new records and UPDATE changed records
commit previous update (e.g. FM DB_COMMiT)

Are you working on a very light configuration?

Re: Performance Issue : MODIFY Z-table from internal table

VXLozano — Fri, 03 Sep 2021 09:48:11 GMT

How did you install SAP in a Sinclair Spectrum? Have your internal tables 4 million fields each? Are your non-buffered tables stored in clay tablets?

Sorry, but that's nonsense. Even if your tables have no index (nor primary keys), an update of 400 rows should be (as Raymond told) almost instantaneous.

Can you provide us more details? A code snipet (using the CODE button, please), the tables structures, etc.

Re: Performance Issue : MODIFY Z-table from internal table

Sandra_Rossi — Fri, 03 Sep 2021 12:18:00 GMT

Even if 400 records is a small number, we don't know here how many records are in the database table!

If the database table has billions of records, that may happen... (depending how the database is configured)

Why are you talking about 3 tables? All have exactly the same issue when independently tested?

NB: I know nothing about "column store" storage, you should ask a HANA database expert.