Performance Issue : MODIFY Z-table from internal table

[sanjana_lingras]

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.

[RaymondGiuseppi]

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?

[VXLozano]

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.

[Sandra_Rossi]

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.