External Organization Delete takes long time to delete and save the component
Tools : 8.56.14
Application : Campus Solutions 9.20.00.000.
ORG_ID_DELET component, used to delete the organization: when we choose an organization to delete it is going to continuous loop for about 10 mins and then saving the component.
** In the Record level save postchange i.e., ORG_RCRDS_VIEW check is being made to see whether the Org id exists.
SQLExec("Select 'X' From " | &TableName | " Where EXT_ORG_ID = :1", EXT_ORG_TBL.EXT_ORG_ID, &Org_Cnt);
Above statement is being run for around 410 Records, if org id exists in any of the records delete statement is run for that record.
This is causing aorund more than 10 mins for the component to complete the porcessing and save.
Application : Campus Solutions 9.20.00.000.
ORG_ID_DELET component, used to delete the organization: when we choose an organization to delete it is going to continuous loop for about 10 mins and then saving the component.
** In the Record level save postchange i.e., ORG_RCRDS_VIEW check is being made to see whether the Org id exists.
SQLExec("Select 'X' From " | &TableName | " Where EXT_ORG_ID = :1", EXT_ORG_TBL.EXT_ORG_ID, &Org_Cnt);
Above statement is being run for around 410 Records, if org id exists in any of the records delete statement is run for that record.
This is causing aorund more than 10 mins for the component to complete the porcessing and save.
0