Re: Why is PGStream.flush() taking so much time?
От | Guido Fiala |
---|---|
Тема | Re: Why is PGStream.flush() taking so much time? |
Дата | |
Msg-id | 200411170856.08915.guido.fiala@dka-gmbh.de обсуждение исходный текст |
Ответ на | Why is PGStream.flush() taking so much time? (Guido Fiala <guido.fiala@dka-gmbh.de>) |
Список | 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 по дате отправления: