Re: Why is PGStream.flush() taking so much time? - Mailing list pgsql-jdbc

From Guido Fiala
Subject Re: Why is PGStream.flush() taking so much time?
Date
Msg-id 200411170856.08915.guido.fiala@dka-gmbh.de
Whole thread Raw
In response to Why is PGStream.flush() taking so much time?  (Guido Fiala <guido.fiala@dka-gmbh.de>)
List pgsql-jdbc
Ok, some more try, here is what
java -Xrunhprof:cpu=samples,depth=40 tells me (application kept busy by user
input, over all it run about 30 seconds):

   1 59.12% 59.12%    5891   556 sun.awt.motif.MToolkit.run
   2  2.25% 61.36%     224  2142 java.net.SocketInputStream.socketRead0
   3  1.71% 63.07%     170  2302 java.net.SocketInputStream.socketRead0
   4  0.57% 63.64%      57  2292 java.net.SocketInputStream.socketRead0
   5  0.55% 64.19%      55  1813 java.net.SocketOutputStream.socketWrite0
   6  0.50% 64.70%      50  2036 java.net.SocketInputStream.socketRead0
   7  0.48% 65.18%      48  2029
sun.awt.motif.MGlobalCursorManager.getCursorPos
   8  0.40% 65.58%      40   549 sun.awt.motif.MToolkit.init
   9  0.38% 65.96%      38  1566 sun.awt.font.NativeFontWrapper.getCharMetrics
  10  0.30% 66.26%      30  1003 f.mb.setConnection
  11  0.28% 66.54%      28   390
org.postgresql.jdbc2.Jdbc2Statement.createResultSet
  12  0.22% 66.76%      22  1383
org.postgresql.jdbc2.Jdbc2Connection.getMetaData
  13  0.22% 66.98%      22  2353 java.net.SocketInputStream.socketRead0
  14  0.22% 67.21%      22  2290 java.net.SocketInputStream.socketRead0
  15  0.21% 67.42%      21   362
org.postgresql.jdbc2.Jdbc2Connection.createStatement

However, it took about 1..3 seconds after each keypress in the application
until the data where displayed in the form (about 10..50 records with 10
columns average) - it feels so slow.
And that although only the motif takes really some time.

pgsql-jdbc by date:

Previous
From: Guido Fiala
Date:
Subject: Re: Why is PGStream.flush() taking so much time?
Next
From: Xavier Poinsard
Date:
Subject: Permission denied error with testGetUDTQualified