Run CE 4.3.0 on Windoze with a repository on SQL Server 2008.
Opening and saving transformations local on the PDI server are very fast, however, remotely over a VPN connection takes 30+ seconds per transformation. It is a cable connection and is generally quick for other uses. In past cases when I've had a DI Server the saving performed reasonably well so I'm guessing the issue is latency as PDI makes a lot of DB transactions when opening/saving the transformations.
My plan B was to go with a File Based repository, but I haven't seen a work around for PDI-4958.
1) Are there settings like connection pooling I should use to improve performance with the repository? Recommendations?
2) Is there a way to address the Slave Server Exists error in setting up a file based repo?
3) Are others not seeing slow repo performance?
Any feedback would be appreciated.