cancel
Showing results for 
Search instead for 
Did you mean: 

SAP SNC Portal DCM screen performance is very slow and times out

Former Member
0 Kudos

Friends,

SAP SNC Portal DCM screen performance is very slow and times out when user trying to pull data using customer location

What are the cleanup activites we can do to improve the overall SNC performance ?

We did open OSS message but so far no reply from SAP , Is there any one faced performance issue ?

User/vendor is complaining about slowness , query is standard SAP and its taking more time .(table - /LIME/NTREE) , It looks like number of data are huge causing this problem related to LIME/NTREE table. What are the options to improve the performance ?

Thanks in Advance

Hanuman Choudhary

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

hi Team,

Pls . note the advise from SAP below, IS there any have experiance of archiveing /LIME records ?

Please advise how to start & what the steps in archiving ?

Thanks in advance

I had a look at the DCM query performance in PH1 system and figured out

that most of the time is spent at the LIME layer of database. The

following LIME tables are having far too many entries and is causing

the bottleneck during the query execution.

/LIME/NLOG_QUAN - 38,165,467

/LIME/PN_ITEM - 19,116,518

/LIME/PN_ITEM_TB - 19,154,124

These tables are storing the historical information about LIME(stock)

updates. Since these table grow with each change/update of stock

information, it will slow down the performance of the system over a

period of time. And to avoid the slow responses, the tables should

ideally be archived on a periodic basis to keep the data volume as

minimal as possible. You may have to discuss with the Business to

determine the number of days of LIME record you would want to retain

in the system. I would strongly recommend you to consider the LIME

archival retaining the minimum days (<=60 days) of historical

information. You can find more information about the Lime Archival

in the Sap Help link:

http://help.sap.com/saphelp_scm2007/helpdata/en/44/2a83121dde23d1e10000000a1553f7/frameset.htm.

Kindly get in touch with your BASIS consultant for the LIME archival.

The application performance should definitely improve after the LIME

archival. Please do not hesitate to get in touch with me in case you

require any further clarification in this regards.

Best Regards

Former Member
0 Kudos

Hi,

Check out SAP note 1344311

Regards,

Nikhil