Speed up SQL developer over XDMCP?
Hi!
Often I have to login to various unix/linux workstations over ssh or VPN, because of restrictions I can not log in the database directly - I have to log in the workstation first, and from there I have access to the database. There is SQL developer installed on each of them and I have to do various maintenance/development tasks using SQL developer. Now I have two options:
- use VNC or similar alternatives (vino/vinagre) to connect to the workstations desktop (this implies there is an active logged in session running on the workstation, otherwise you can not connect this way)
- use XWindows's XDMCP protocol and run SQL developer on remote machine and have it display its window on my computer. This way there is no need for an active session on the remote computer and even if there is one, I can work independently of other users on the remote workstation (no need for shared session).
The latter option is much more user friendly, however, it has a drawback. SQL developer is unbearably slow over XDMCP. You can feel the lag when using it even over loopback network adapter, you can immagine how it feels over a slow internet connection. It is unusable.
Is there any way to speed up SQL developer over XDMCP? It is a fine tool and getting beter with every release, but for doing any remote work over (not even "so" slow) network connections it really does not cut it - I have to resort to sql+ ( and suddenly I get the feeling it is 1990 again ;) )
If you have ssh server installed on your linux machine, here is a quick test run to see how it feels using SQL devleloper over XDMCP (this is the fastest way of using ssh I know of: -C means compress traffic and -c arcfour128 is the fastest cryptographic function in ssh, and even this way there is noticeable lag in user interface):
[alex@alex ~]$ ssh -X -Y -C -c arcfour128 localhost
alex@localhost's password:
Last login: Thu Mar 10 10:22:55 2011 from localhost
[alex@alex ~]$ cd prg/oracle/sqldeveloperEA4/sqldeveloper/
[alex@alex sqldeveloper]$ ./sqldeveloper.sh
Is there any way to speed up SQL developer over XDMCP?
bye
Aleksander