Skip to Content
0
Former Member
Jan 20, 2009 at 02:19 PM

A time problem with a SQL sentence wit CRMD_SRV_OSSET Transparent table

60 Views

Hi,

I 've an issue when I Execute the "Verif. Extractor S-API" (RSA3 transaction). I checked this transaction, with this parameters:

Datasource: 0CRM_OPPT_H

Request ID TEST

Data Records / Calls 100

Display Extr. Calls 10

Update mode F

Selections: OBJECT_ID -> 0000002230, 0000002231

When I Execute the transaction, previously I activated the SQL trace in ST05 transaction (to can check posssible problems).

When the Process finished, I was looking the Display Trace and I looked that, for every item, the next SQL statement, needs 15 seconds per item. Really strange. In my case, normally I'll need process this SQL 3 million times, because I've 3 million items in CRMD_SRV_OSSET transparent table.

Standard Function : CRM_SERVICE_OS_SELECT_S_DB

Select statement: "SELECT * FROM CRMD_SRV_OSSET

INTO TABLE LT_OSSET

WHERE GUID_SET = IV_GUID_SET

ORDER BY PRIMARY KEY ."

Can someone help me?

Thanks,

Sergio