Re: Why is PGStream.flush() taking so much time?

From: Guido Fiala <guido(dot)fiala(at)dka-gmbh(dot)de>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Why is PGStream.flush() taking so much time?
Date: 2004-11-17 07:56:08
Message-ID: 200411170856.08915.guido.fiala@dka-gmbh.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Xavier Poinsard 2004-11-17 15:25:58 Permission denied error with testGetUDTQualified
Previous Message Guido Fiala 2004-11-17 07:36:04 Re: Why is PGStream.flush() taking so much time?