CPS-1173 : Deletion Performance improvement proposal

References

<optional, assumptions are like decision made up front ie. everyone agrees on the answer but they are important to mention>

#	Assumption	Notes

#	Assumption	Notes
1

#	Issue	Notes	Decision

#	Issue	Notes	Decision
1	Deleting cm handle one after another.	Can be processed into batchs
2	Getting cm handles by id	It should be converted to fetch by list of xpath (CPS Core)	Fetch by list of xpath using temp table
3	Delete schema set operation	cascade all	Native query using temp table
4	^{Updating CmHandleState}	Use batch operation to update states
5	How to do performance test ?
6	Async response ?

<Note. use green for closed issues, yellow for important ones if needed>

< we do not want to dictate the remainder of an analysis it will depend on the type of user story at hand>