if it works fine in your LAN, then you can't optimize the statements except the amount of data that ist transferred (e.g dont use "select * from ..." but "select neededcol1,neededcol2,.... from ...". For working with small connections its best to write a server which transfers the data to the client (years ago I wrote a small JDBC-Driver). The Server can ZIP the data before transferring:
ObjectOutputStream -> DeflaterStream -> ByteArrayStream -> the Byte[] you get can be send over a normal socket Stream.
Regards
Andreas Fuchs
Andre Heine wrote:
Hi all, I've written an Java application with JDBC and SAP DB. All functions work fine with SAP-DB, but sometime I need an SAP-DB connection over ISDN.In these case, my application works very slowly ;( I can't work with the application over 64k-ISDN, my menu's only opened after a few minutes! How can I boost the connection? Is there any configuration option to do this? It is possible to optimize my JDBC-Code? Thanks for any hint and experience! Regards Andre
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
