Hello, try to check your statements and the amount of data they return, e.g. by executing them over ISDN using SQL-Studio. Don't expect too much from such a network connection - 32KBytes of data (one *full* packet of the default packet size to the database, as may happen when you do a SELECT with a large result set) takes approx. 4 seconds using a 64kbit line. You may want possibly to experiment with Statement.setFetchSize(1) which will result in having only 1 row transmitted when navigating through a result set, if your application provides some activity *while* fetching through result sets.
Regards Alexander Schr�der SAP Labs Berlin > -----Original Message----- > From: Andre Heine [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 18, 2002 1:09 PM > To: Marcin P; [EMAIL PROTECTED] > Subject: Re: Optimize SQL-Statements for 64-k ISDN ?? > > > Hi Marcin, > > "Marcin P" <[EMAIL PROTECTED]> schrieb im Newsbeitrag > atpkll$kii$[EMAIL PROTECTED]">news:atpkll$kii$[EMAIL PROTECTED]... > > Could You give us more information? > > My application works fine in our local net. The SQLStudio > work fine, too ( > It works fine but slow over ISDN)! > > In our local net is the performance OK > > > When your connection is finally done, and > > your app is running, do the operations take a long time? > > I think so, some menues will be generated dynamically by some > select-statements, it takes some minutes to open it. Or I can't > use the application completly... > > In the beginning we has fixed some problems with the netowork, SAP-DB > need to know the clientsnames via /etc/hosts or dns. > > Without hosts/dns the connect will takes a long time, but that > can't be the problem. > > All clients can be "pinged" with there names..., also the > clients can ping the > server with name! > > That ist correctly configured and works with other Tools fast > (mysql, my > self-written-java-server) > > I assume, that some statements must/could be optimized... > > How can I debug the statements, or how can I see which > function/ method > need all the time? > > Is that generally possible with SAP-DB? > > > Because if the only problem is only with connecting it seems > > to be rather a network problem. > > Possible, but what could it be? > > > When I first installed SAP DB (oh, it was more than year ago...;) ) > > I had problems with connecting to database > > from other machines in my network... > > That's works :)) > > > So I turned to my network admins, and they have found, that > > two solutions were available - putting your machine server > in lmhost file > > or add this machine to DNS-server you are using for this > > network-connection. > > It is working fine on my side. > > For me too... > > Thx & greetings > > Andre > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
