RPM Project Upload Performance

[Former Member]

Hi,

We are using RPM for the first time and users are noticing very slow performance when uploading projects into the system. It is taking approx 20 minutes to upload 150 projects. We are on RPM 4.5 with BW 7.00. We don't have cProjects installed. I have two questions around this:

1) What are the speeds of uploads that other people are seeing?

2) Is there anything we can do to speed up our uploads? It does not take any length of time for one particular step but each project is going through numerous reads/inserts to create the project.

Here is an extract from the ST05 trace:

14:24:49.334 12 CL_CGPL CGPL_HIER REOPEN 36 0 R/3 1 SELECT WHERE "CLIENT" = '100' AND "GUID" = 0x4B59AC3EC2D21EAFE10000000E40200C

14:24:49.336 601 CL_CGPL CGPL_HIER FETCH 36 1 1 0 R/3 1

14:24:49.339 13 CL_CGPL CGPL_HIER REOPEN 36 0 R/3 1 SELECT WHERE "CLIENT" = '100' AND "GUID" = 0x4B59AC61C2D21EAFE10000000E40200C

14:24:49.339 723 CL_CGPL CGPL_HIER FETCH 36 1 1 0 R/3 1

14:24:49.341 13 CL_CGPL CGPL_RELA REOPEN 49 0 R/3 1 SELECT WHERE "CLIENT" = '100' AND ( "PREDEC_PROJECT" = 0x4B59A97EC2D21EAFE10000000E40200C OR

14:24:49.341 616 CL_CGPL CGPL_RELA FETCH 49 478 0 1403 R/3 1

14:24:49.342 14 CL_CGPL CGPL_RELA REOPEN 178 0 R/3 1 SELECT WHERE "CLIENT" = '100' AND ( "PREDEC_PROJECT" = 0x4B59AB7BC2D21EAFE10000000E40200C AND

14:24:49.342 12.173 CL_CGPL CGPL_RELA FETCH 178 478 0 1403 R/3 1

14:24:49.355 14 CL_CGPL CGPL_RELA REOPEN 121 0 R/3 1 SELECT WHERE "CLIENT" = '100' AND ( "PREDEC_PROJECT" = 0x4B59ABFEC2D21EAFE10000000E40200C AND

14:24:49.355 10.380 CL_CGPL CGPL_RELA FETCH 121 478 0 1403 R/3 1

14:24:49.366 14 SAPLCRM CRM_JSTO REOPEN 215 0 R/3 1 SELECT WHERE "MANDT" = '100' AND "OBJNR" IN ( 0x4B59AB7BC2D21EAFE10000000E40200C , 0x4B59AB90

14:24:49.367 526 SAPLCRM CRM_JSTO FETCH 215 985 0 1403 R/3 1

14:24:49.367 12 SAPLCRM CRM_JSTO REOPEN 57 0 R/3 1 SELECT WHERE "MANDT" = '100' AND "OBJNR" IN ( 0x4B59ABFEC2D21EAFE10000000E40200C , 0x4B59AC1D

14:24:49.367 402 SAPLCRM CRM_JSTO FETCH 57 985 0 1403 R/3 1

14:24:49.368 12 SAPLCRM CRM_JEST REOPEN 43 0 R/3 1 SELECT WHERE "MANDT" = '100' AND "OBJNR" IN ( 0x4B59AB7BC2D21EAFE10000000E40200C , 0x4B59AB90

14:24:49.368 443 SAPLCRM CRM_JEST FETCH 43 1.250 0 1403 R/3 1

14:24:49.369 12 SAPLCRM CRM_JEST REOPEN 102 0 R/3 1 SELECT WHERE "MANDT" = '100' AND "OBJNR" IN ( 0x4B59ABFEC2D21EAFE10000000E40200C , 0x4B59AC1D

14:24:49.369 434 SAPLCRM CRM_JEST FETCH 102 1.250 0 1403 R/3 1

14:24:49.374 14 / /CL_B / /BUCKET REOPEN 206 0 R/3 1 SELECT WHERE "CLIENT" = '100' AND "GUID" = 0x4B59A97EC2D21EAFE10000000E40200C

14:24:49.374 968 / /CL_B / /BUCKET FETCH 206 222 1 1403 R/3 1

14:24:49.376 15 / /CL_B / /BUCKET REOPEN 185 0 R/3 1 SELECT WHERE "CLIENT" = '100' AND "GUID" = 0x4B59A97EC2D21EAFE10000000E40200C

14:24:49.376 522 / /CL_B / /BUCKET FETCH 185 411 0 1403 R/3 1

14:24:49.377 13 / /CL_B / /BUCKET REOPEN 187 0 R/3 1 SELECT WHERE "CLIENT" = '100' AND "GUID" = 0x4B59A97EC2D21EAFE10000000E40200C

14:24:49.377 509 / /CL_B / /BUCKET FETCH 187 173 6 1403 R/3 1

14:24:49.418 27 CL_CGPL CGPL_PROJ REOPEN 149 0 R/3 1 SELECT WHERE "CLIENT" = '100' AND "GUID" = 0x4B59A99BC2D21EAFE10000000E40200C

14:24:49.418 965 CL_CGPL CGPL_PROJ FETCH 149 161 1 1403 R/3 1

14:24:49.419 12 CL_CGPL CGPL_R3_A REOPEN 150 0 R/3 1 SELECT WHERE "MANDT" = '100' AND "GUID" = 0x4B59A99BC2D21EAFE10000000E40200C

14:24:49.419 323 CL_CGPL CGPL_R3_A FETCH 150 214 0 1403 R/3 1

14:24:49.421 15 CL_CGPL CGPL_TASK REOPEN 151 0 R/3 1 SELECT WHERE "CLIENT" = '100' AND "PROJECT_GUID" = 0x4B59A99BC2D21EAFE10000000E40200C

14:24:49.421 676 CL_CGPL CGPL_TASK FETCH 151 161 0 1403 R/3 1

14:24:49.423 25 CL_CGPL CGPL_HIER REOPEN 122 0 R/3 1 SELECT WHERE "CLIENT" = '100' AND ( "GUID" = 0x4B59A99BC2D21EAFE10000000E40200C OR "PROJECT_G

14:24:49.423 584 CL_CGPL CGPL_HIER FETCH 122 485 1 1403 R/3 1

14:24:49.425 13 CL_CGPL CGPL_HIER REOPEN 30 0 R/3 1 SELECT WHERE "CLIENT" = '100' AND "UP" = 0x4B59A99BC2D21EAFE10000000E40200C AND "PROJECT_GUID

14:24:49.425 504 CL_CGPL CGPL_HIER FETCH 30 485 5 1403 R/3 1

14:24:49.426 12 CL_CGPL CGPL_PROJ REOPEN 172 0 R/3 1 SELECT WHERE "CLIENT" = '100' AND "GUID" IN ( 0x4B59ACA7C2D21EAFE10000000E40200C , 0x4B59ACBE

14:24:49.426 794 CL_CGPL CGPL_PROJ FETCH 172 161 5 1403 R/3 1

14:24:49.427 13 CL_CGPL CGPL_R3_A REOPEN 67 0 R/3 1 SELECT WHERE "MANDT" = '100' AND "GUID" IN ( 0x4B59ACA7C2D21EAFE10000000E40200C , 0x4B59ACBEC

14:24:49.427 404 CL_CGPL CGPL_R3_A FETCH 67 214 0 1403 R/3 1

14:24:49.430 13 CL_CGPL CGPL_HIER REOPEN 36 0 R/3 1 SELECT WHERE "CLIENT" = '100' AND "GUID" = 0x4B59AC92C2D21EAFE10000000E40200C

14:24:49.430 556 CL_CGPL CGPL_HIER FETCH 36 1 1 0 R/3 1

14:24:49.435 29 CL_CGPL CGPL_HIER REOPEN 36 0 R/3 1 SELECT WHERE "CLIENT" = '100' AND "GUID" = 0x4B59ACA7C2D21EAFE10000000E40200C

14:24:49.435 619 CL_CGPL CGPL_HIER FETCH 36 1 1 0 R/3 1

14:24:49.438 13 CL_CGPL CGPL_HIER REOPEN 36 0 R/3 1 SELECT WHERE "CLIENT" = '100' AND "GUID" = 0x4B59ACBEC2D21EAFE10000000E40200C

And here is an extract from Oracle AWR report showing numerous steps against the same tables but each step being relatively quick:

Elapsed Time (s) CPU Time (s) Executions Elap per Exec (s) % Total DB Time SQL Id SQL Module SQL Text

62 61 6,379 0.01 4.77 bs7hy8cd8us50 CL_CGPL_PERSISTENCY===========CP SELECT * FROM "CGPL_RELATION" ...

57 56 10,543 0.01 4.36 g4mwu3w1kxdu1 CL_SQL_STATEMENT==============CP select count(*) from user_tabl...

30 27 149 0.20 2.33 d753g4chwurmd SAPLRZD1 SELECT * FROM "RSZELTXREF" WHE...

Thanks,

Adrian

[Former Member]

And if anyone can tell me how to add carriage returns on this forum, that would be also appreciated and make the post a lot more readable!