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.
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? |