PCM_OP_CUST_MODIFY_CUSTOMER taking too much time for completion
In production, performance testing in progress. We have around 1million account in our brm db.
We are placing end2end order and it is getting completed successfully.
But modify customer opcode is taking more time to complete in BRM.
Below is the pstack.
Seconds Type Opcode (flags, notes)
0.000000000 Enter PCM_OP_CUST_MODIFY_CUSTOMER (0x0)
0.000707013 .Enter PCM_OP_READ_FLDS (0x0)
0.002840458 .Exit PCM_OP_READ_FLDS (0x40000000) - from DM 0.0.0.1
0.003020682 .Enter PCM_OP_TRANS_OPEN (0x10000)
0.003146806 .Exit PCM_OP_TRANS_OPEN (0x10000)
0.003301361 .Enter PCM_OP_ACT_USAGE (0x80)
0.003525678 ..Enter PCM_OP_TRANS_OPEN (0x10080)
0.003715289 ..Exit PCM_OP_TRANS_OPEN (0x10080)
Tagged:
0