Checked with sir Roland if the application successfully finished the parsing of the XML yesterday, and as per sir Roland, it does, and it finished faster. Advised that the application will be checked for optimization and will monitor the query executing in the server.