Hi Pavan,
I only looked at your XPATH and noticed there are a lot of ‘and’ & ‘or’ conditions used.
Its not good practice to do that. Certainly this will lead to performance issues.
Without understanding your domain model, requirement and the amount of data you are dealing with, a simple action I would suggest, which could bring some improvement is:
- Split your XPATH without conditions
- Have multiple retrieval’s for each condition
- Join them and return it
- Check if you have applied indexing
Entities and Relations
APL Relations