It seems I might able to resolve the issue. Thanks to this post N1QL queries timing out when run in java sdk. Still I’ll wait for at least two to three days just to making sure everything is ok.
Thank you @ingenthr you are a big help.
I am still looking ans for the below
2>Thanks for the clarification. Is there any endpoint I need to tune to increase get(doc) or insert(doc) like query? Cuz tuning the queryEndpoint really increase the performance drastically for which I am really glad.