Symptom
- Performance issue with SMP 3.0 SP06
- SELECT VALUE_ID, CREATED_MS, CREATED_BY, CREATED_FROM, CREATED_WITH, LAST_MODIFIED, LONG_BINARY_VALUE, LONG_STRING_VALUE, PROP_ID, STRING_VALUE FROM SMP_CLUSTER_PROP_VALUE WHERE (PROP_ID = :1 )
- SQL statement is run 1000 times in an hour, and each call takes couple seconds to respond, it causes server to become non-responsive
- The query return a large amount of "old" data
Read more...
Environment
SAP Mobile Platform 3.0 SP06
Product
SAP Mobile Platform 3.0
Keywords
Performance Database SMP_CLUSTER_PROP_VALUE DBMS , KBA , MOB-ONP , SAP Mobile Platform on Premise , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.