We have a interface which receives a request from HTTP call and based on this request data will be fetched through rfc and inserted into the Database.
This is currently in production and users are complaining that performance is very very slow. Multiple requests will be raised for this interface what i have observed is that some database operations are in still running mode as a result its causing other threads too are also taking longer time.
We have servers at different geographical locations and i think netwrok latency may be one of the reason for causing this.
Is there any other ways where i can improve the performance of the same
Your replies will be valuable to me