Poor performance in SAP DS 4.2 Designer
We experience poor performance in the Designer every time we do functions which involves Repositories. Especially against the central repository (CR).
Startup of the Designer takes about 20 secs when not connecting to CR. When also connecting to CR, 60-90 secs. Other tasks like "get latest" are also very slow. Get latest on the biggest jobs takes about half an hour. Even a check out of a small table takes more than a minute. When running from home office over VPN, the responetimes multiply by 5 (25Mb fiber connection).
We have noticed that the responsetimes have increased considerably over time, as the number of objects grows. We have now 530 dataflows (3640 rows in AL_LANG for theese, incl historical versions). The number of tables in AL_SCHEMA is 780, 4809 rows incl history. We do observe in Wireshark that thousands of SQL calls are issued when launching the server.
We are running repositories on SAP Sybase ASE 15.5, on Linux (Red Hat). Designer run on Windows 7. All DS servers also run on Linux.
We have tried some measures, like monitoring the sybase server, not finding anything except good health.
Also have connected the pc on as directly to the database server as possible, with no measurable effect. This to check wheather a closer position in the network would solve the problem.
Can anyone help us?