Difficult topic, as working across the world is time consuming, from the top of my head:
There is of course the connection itself. I image you're working with latency in 250-400ms range, maybe even more?
Check with ISP and IT if there is anything to do with the connections. Change of ISP, change of equipment, upgrade. These are means to up speed, lower latency and get higher quality with less packet loss.
I understand you already have a replicated archive server(?). The lag is the client querying the SQL database.
You can implement replicated SQL databases using SQL Enterprise. It costs, but if your design team/company is big enough it might be worth the money. Still, this replicated database is for READ ONLY queries, meaning anything that changes with a file will still contact the overseas SQL server and there will be lag. Check in and check out mainly. Navigating folders is also a SQL query, requesting information on all files in the folders to display in columns or file info. You can turn off all refresh options in SOLIDWORKS Add-in, to make some lag within SOLIDWORKS go away. Keep information in data and folder cards to a minimum.
Thanks for your response,
Yes, We have replicated archive server at Coimbatore-India & being replicated right now,
Your imagine is right ! We are working in working with latency in 250-515 ms range, I will ask my IS team support to reduce Latency also could you advice to what will be range of latency to work smooth & smart from different country
I have a customer who has done a lot of work with connection. It's a small branch office in China with SQL server in Norway.
They have updated router and firewall firmware and software, run periodic reboots, upgraded lines. They are still working in a range of 250-300 ms latency, but the quality is improved so the users in China have reported better performance overall. They have also done some work on their SQL server performance, which is hosted at their ISP. Of course i don't know all the details, because it's the company's IT dept. who is doing all this. Anyway, i guess you would be working in about the same latency range, but i point out that my experience is from Norway to other parts of the world, and not from US.
Thanks for your valued reply Martin,