The Repository is a client-server application, in which the Client issues SQL statements via an ODBC connection to be executed on the database server. While such a system provides acceptable performance on a Local Area Network (LAN), it may be less effective on a Wide Area Network (WAN).
SQL statements require several network packets, each of which must go back and forth before the next one is issued. While a LAN connection typically has a ping time of less than 10ms; a WAN connection (passing through the Internet via a Virtual Private Network (VPN) connection) has a typical ping of over 100ms.
The PowerDesigner repository proxy is an optional program that receives requests from client workstations and translates them into a more efficient proprietary format for communication with the repository server. With client request pooling and sophisticated caching, the proxy can considerably improve performance, particularly if clients will be connecting over a WAN.
Ideally, if your repository server is a fast, modern machine, you should install the proxy directly on the same machine. Otherwise, you should install the proxy on another server on the same LAN.
The repository administrator will set up the repository proxy.
Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com
Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.