So the problem here was that the database was actually on a memory stick... which normally has decent performance, but apparently the H2 database doesn't like it. I tried moving it to a normal drive and then to a SSD and it worked much better on the other drive types. Thanks!
On Wednesday, June 12, 2013 8:42:50 PM UTC-7, TrendTimer.com wrote: > > it's a 360mb database. I'm using the latest drivers. Does anyone have > any ideas about this? I'm doing a SHUTDOWN COMPACT after each use. > 18 seconds is a pretty long wait just for this. Thanks in advance. > > Test > successful<http://192.168.1.9:8082/test.do?jsessionid=9b327197538372c479c11061e32deed1#> > Profiler: top 3 stack trace(s) of 18844 ms: > 9275/40414 (22%): > at java.net.DualStackPlainSocketImpl.accept0(Native Method) > at > java.net.DualStackPlainSocketImpl.socketAccept(DualStackPlainSocketImpl.java:121) > > at > java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:398) > at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:183) > at java.net.ServerSocket.implAccept(ServerSocket.java:522) > at java.net.ServerSocket.accept(ServerSocket.java:490) > at org.h2.server.TcpServer.listen(TcpServer.java:239) > at org.h2.tools.Server.run(Server.java:547) > at java.lang.Thread.run(Thread.java:722) > 9275/40414 (22%): > at java.net.DualStackPlainSocketImpl.accept0(Native Method) > at > java.net.DualStackPlainSocketImpl.socketAccept(DualStackPlainSocketImpl.java:121) > > at > java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:398) > at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:183) > at java.net.ServerSocket.implAccept(ServerSocket.java:522) > at java.net.ServerSocket.accept(ServerSocket.java:490) > at org.h2.server.pg.PgServer.listen(PgServer.java:182) > at org.h2.tools.Server.run(Server.java:547) > at java.lang.Thread.run(Thread.java:722) > 9275/40414 (22%): > at java.net.DualStackPlainSocketImpl.accept0(Native Method) > at > java.net.DualStackPlainSocketImpl.socketAccept(DualStackPlainSocketImpl.java:121) > > at > java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:398) > at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:183) > at java.net.ServerSocket.implAccept(ServerSocket.java:522) > at java.net.ServerSocket.accept(ServerSocket.java:490) > at org.h2.server.web.WebServer.listen(WebServer.java:341) > at org.h2.tools.Server.run(Server.java:547) > at java.lang.Thread.run(Thread.java:722) > summary: > 31%: org.h2.store.fs > 22%: org.h2.server.web > 22%: org.h2.server.pg > 22%: org.h2.server > . > Profiler: top 3 stack trace(s) of 6647 ms: > 3278/15412 (21%): > at java.net.DualStackPlainSocketImpl.accept0(Native Method) > at > java.net.DualStackPlainSocketImpl.socketAccept(DualStackPlainSocketImpl.java:121) > > at > java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:398) > at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:183) > at java.net.ServerSocket.implAccept(ServerSocket.java:522) > at java.net.ServerSocket.accept(ServerSocket.java:490) > at org.h2.server.TcpServer.listen(TcpServer.java:239) > at org.h2.tools.Server.run(Server.java:547) > at java.lang.Thread.run(Thread.java:722) > 3278/15412 (21%): > at java.net.DualStackPlainSocketImpl.accept0(Native Method) > at > java.net.DualStackPlainSocketImpl.socketAccept(DualStackPlainSocketImpl.java:121) > > at > java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:398) > at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:183) > at java.net.ServerSocket.implAccept(ServerSocket.java:522) > at java.net.ServerSocket.accept(ServerSocket.java:490) > at org.h2.server.pg.PgServer.listen(PgServer.java:182) > at org.h2.tools.Server.run(Server.java:547) > at java.lang.Thread.run(Thread.java:722) > 3278/15412 (21%): > at java.net.DualStackPlainSocketImpl.accept0(Native Method) > at > java.net.DualStackPlainSocketImpl.socketAccept(DualStackPlainSocketImpl.java:121) > > at > java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:398) > at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:183) > at java.net.ServerSocket.implAccept(ServerSocket.java:522) > at java.net.ServerSocket.accept(ServerSocket.java:490) > at org.h2.server.web.WebServer.listen(WebServer.java:341) > at org.h2.tools.Server.run(Server.java:547) > at java.lang.Thread.run(Thread.java:722) > summary: > 36%: org.h2.store.fs > 21%: org.h2.server.web > 21%: org.h2.server.pg > 21%: org.h2.server > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en-US. For more options, visit https://groups.google.com/groups/opt_out.
