Hi, The traces are below. Note that I switched to one table (instead of two previously). The row count is now 5895778.
run: *** H2 PROFILER OUTPUT BELOW *** Profiler: top 10 stack trace(s) of 24453 ms [build-153]: 318/1563 (20%): at java.io.RandomAccessFile.readBytes(Native Method) at java.io.RandomAccessFile.read(RandomAccessFile.java:322) at java.io.RandomAccessFile.readFully(RandomAccessFile.java:381) at org.h2.store.FileStore.readFully(FileStore.java:285) at org.h2.store.PageStore.readPage(PageStore.java:1270) at org.h2.store.PageStore.getPage(PageStore.java:706) at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:222) at org.h2.index.PageDataNode.getNextPage(PageDataNode.java:226) at org.h2.index.PageDataLeaf.getNextPage(PageDataLeaf.java:391) at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:90) at org.h2.index.PageDataCursor.next(PageDataCursor.java:49) at org.h2.index.IndexCursor.next(IndexCursor.java:235) at org.h2.table.TableFilter.next(TableFilter.java:352) at org.h2.command.dml.Select.queryFlat(Select.java:513) at org.h2.command.dml.Select.queryWithoutCache(Select.java:614) at org.h2.command.dml.Query.query(Query.java:269) at org.h2.command.dml.Query.query(Query.java:239) at org.h2.command.dml.Query.query(Query.java:37) at org.h2.command.CommandContainer.query(CommandContainer.java:78) at org.h2.command.Command.executeQuery(Command.java:181) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java: 96) at org.h2.store.LobStorage.removeAllForTable(LobStorage.java:138) at org.h2.engine.Database.close(Database.java:1066) at org.h2.engine.Database.removeSession(Database.java:953) at org.h2.engine.Session.close(Session.java:572) at org.h2.jdbc.JdbcConnection.close(JdbcConnection.java:337) at org.aaaStorage.close(MatDbStorage.java:316) at h2perftest.Main.main(Main.java:29) 312/1563 (19%): at java.io.RandomAccessFile.readBytes(Native Method) at java.io.RandomAccessFile.read(RandomAccessFile.java:322) at java.io.RandomAccessFile.readFully(RandomAccessFile.java:381) at org.h2.store.FileStore.readFully(FileStore.java:285) at org.h2.store.PageStore.readPage(PageStore.java:1270) at org.h2.store.PageStore.getPage(PageStore.java:706) at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:222) at org.h2.index.PageDataNode.getNextPage(PageDataNode.java:226) at org.h2.index.PageDataLeaf.getNextPage(PageDataLeaf.java:391) at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:90) at org.h2.index.PageDataCursor.next(PageDataCursor.java:49) at org.h2.index.IndexCursor.next(IndexCursor.java:235) at org.h2.table.TableFilter.next(TableFilter.java:352) at org.h2.command.dml.Select.queryFlat(Select.java:513) at org.h2.command.dml.Select.queryWithoutCache(Select.java:614) at org.h2.command.dml.Query.query(Query.java:269) at org.h2.command.dml.Query.query(Query.java:239) at org.h2.command.dml.Query.query(Query.java:37) at org.h2.command.CommandContainer.query(CommandContainer.java:78) at org.h2.command.Command.executeQuery(Command.java:181) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java: 96) at org.h2.store.LobStorage.removeAllForTable(LobStorage.java:138) at org.h2.store.LobStorage.removeAllForTable(LobStorage.java:147) at org.h2.engine.Database.close(Database.java:1066) at org.h2.engine.Database.removeSession(Database.java:953) at org.h2.engine.Session.close(Session.java:572) at org.h2.jdbc.JdbcConnection.close(JdbcConnection.java:337) at org.aaaStorage.close(MatDbStorage.java:316) at h2perftest.Main.main(Main.java:29) 72/1563 (4%): at org.h2.store.PageStore.getPage(PageStore.java:699) at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:222) at org.h2.index.PageDataLeaf.getNextPage(PageDataLeaf.java:390) at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:90) at org.h2.index.PageDataCursor.next(PageDataCursor.java:49) at org.h2.index.IndexCursor.next(IndexCursor.java:235) at org.h2.table.TableFilter.next(TableFilter.java:352) at org.h2.command.dml.Select.queryFlat(Select.java:513) at org.h2.command.dml.Select.queryWithoutCache(Select.java:614) at org.h2.command.dml.Query.query(Query.java:269) at org.h2.command.dml.Query.query(Query.java:239) at org.h2.command.dml.Query.query(Query.java:37) at org.h2.command.CommandContainer.query(CommandContainer.java:78) at org.h2.command.Command.executeQuery(Command.java:181) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java: 96) at org.h2.store.LobStorage.removeAllForTable(LobStorage.java:138) at org.h2.store.LobStorage.removeAllForTable(LobStorage.java:147) at org.h2.engine.Database.close(Database.java:1066) at org.h2.engine.Database.removeSession(Database.java:953) at org.h2.engine.Session.close(Session.java:572) at org.h2.jdbc.JdbcConnection.close(JdbcConnection.java:337) at org.aaaStorage.close(MatDbStorage.java:316) at h2perftest.Main.main(Main.java:29) 68/1563 (4%): at org.h2.value.ValueBoolean.getBoolean(ValueBoolean.java:57) at org.h2.expression.Expression.getBooleanValue(Expression.java:180) at org.h2.command.dml.Select.queryFlat(Select.java:515) at org.h2.command.dml.Select.queryWithoutCache(Select.java:614) at org.h2.command.dml.Query.query(Query.java:269) at org.h2.command.dml.Query.query(Query.java:239) at org.h2.command.dml.Query.query(Query.java:37) at org.h2.command.CommandContainer.query(CommandContainer.java:78) at org.h2.command.Command.executeQuery(Command.java:181) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java: 96) at org.h2.store.LobStorage.removeAllForTable(LobStorage.java:138) at org.h2.engine.Database.close(Database.java:1066) at org.h2.engine.Database.removeSession(Database.java:953) at org.h2.engine.Session.close(Session.java:572) at org.h2.jdbc.JdbcConnection.close(JdbcConnection.java:337) at org.aaaStorage.close(MatDbStorage.java:316) at h2perftest.Main.main(Main.java:29) 50/1563 (3%): at org.h2.store.PageStore.getPage(PageStore.java:699) at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:222) at org.h2.index.PageDataLeaf.getNextPage(PageDataLeaf.java:390) at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:90) at org.h2.index.PageDataCursor.next(PageDataCursor.java:49) at org.h2.index.IndexCursor.next(IndexCursor.java:235) at org.h2.table.TableFilter.next(TableFilter.java:352) at org.h2.command.dml.Select.queryFlat(Select.java:513) at org.h2.command.dml.Select.queryWithoutCache(Select.java:614) at org.h2.command.dml.Query.query(Query.java:269) at org.h2.command.dml.Query.query(Query.java:239) at org.h2.command.dml.Query.query(Query.java:37) at org.h2.command.CommandContainer.query(CommandContainer.java:78) at org.h2.command.Command.executeQuery(Command.java:181) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java: 96) at org.h2.store.LobStorage.removeAllForTable(LobStorage.java:138) at org.h2.engine.Database.close(Database.java:1066) at org.h2.engine.Database.removeSession(Database.java:953) at org.h2.engine.Session.close(Session.java:572) at org.h2.jdbc.JdbcConnection.close(JdbcConnection.java:337) at org.aaaStorage.close(MatDbStorage.java:316) at h2perftest.Main.main(Main.java:29) 48/1563 (3%): at org.h2.value.Value.cache(Value.java:343) at org.h2.value.ValueLong.get(ValueLong.java:195) at org.h2.store.Data.readValue(Data.java:639) at org.h2.index.PageDataLeaf.readRow(PageDataLeaf.java:598) at org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:329) at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:97) at org.h2.index.PageDataCursor.next(PageDataCursor.java:49) at org.h2.index.IndexCursor.next(IndexCursor.java:235) at org.h2.table.TableFilter.next(TableFilter.java:352) at org.h2.command.dml.Select.queryFlat(Select.java:513) at org.h2.command.dml.Select.queryWithoutCache(Select.java:614) at org.h2.command.dml.Query.query(Query.java:269) at org.h2.command.dml.Query.query(Query.java:239) at org.h2.command.dml.Query.query(Query.java:37) at org.h2.command.CommandContainer.query(CommandContainer.java:78) at org.h2.command.Command.executeQuery(Command.java:181) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java: 96) at org.h2.store.LobStorage.removeAllForTable(LobStorage.java:138) at org.h2.store.LobStorage.removeAllForTable(LobStorage.java:147) at org.h2.engine.Database.close(Database.java:1066) at org.h2.engine.Database.removeSession(Database.java:953) at org.h2.engine.Session.close(Session.java:572) at org.h2.jdbc.JdbcConnection.close(JdbcConnection.java:337) at org.aaaStorage.close(MatDbStorage.java:316) at h2perftest.Main.main(Main.java:29) 41/1563 (2%): at org.h2.value.Value.cache(Value.java:343) at org.h2.value.ValueLong.get(ValueLong.java:195) at org.h2.store.Data.readValue(Data.java:639) at org.h2.index.PageDataLeaf.readRow(PageDataLeaf.java:598) at org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:329) at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:97) at org.h2.index.PageDataCursor.next(PageDataCursor.java:49) at org.h2.index.IndexCursor.next(IndexCursor.java:235) at org.h2.table.TableFilter.next(TableFilter.java:352) at org.h2.command.dml.Select.queryFlat(Select.java:513) at org.h2.command.dml.Select.queryWithoutCache(Select.java:614) at org.h2.command.dml.Query.query(Query.java:269) at org.h2.command.dml.Query.query(Query.java:239) at org.h2.command.dml.Query.query(Query.java:37) at org.h2.command.CommandContainer.query(CommandContainer.java:78) at org.h2.command.Command.executeQuery(Command.java:181) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java: 96) at org.h2.store.LobStorage.removeAllForTable(LobStorage.java:138) at org.h2.engine.Database.close(Database.java:1066) at org.h2.engine.Database.removeSession(Database.java:953) at org.h2.engine.Session.close(Session.java:572) at org.h2.jdbc.JdbcConnection.close(JdbcConnection.java:337) at org.aaaStorage.close(MatDbStorage.java:316) at h2perftest.Main.main(Main.java:29) 40/1563 (2%): at org.h2.store.Data.readVarLong(Data.java:1097) at org.h2.store.Data.readValue(Data.java:639) at org.h2.index.PageDataLeaf.readRow(PageDataLeaf.java:598) at org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:329) at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:97) at org.h2.index.PageDataCursor.next(PageDataCursor.java:49) at org.h2.index.IndexCursor.next(IndexCursor.java:235) at org.h2.table.TableFilter.next(TableFilter.java:352) at org.h2.command.dml.Select.queryFlat(Select.java:513) at org.h2.command.dml.Select.queryWithoutCache(Select.java:614) at org.h2.command.dml.Query.query(Query.java:269) at org.h2.command.dml.Query.query(Query.java:239) at org.h2.command.dml.Query.query(Query.java:37) at org.h2.command.CommandContainer.query(CommandContainer.java:78) at org.h2.command.Command.executeQuery(Command.java:181) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java: 96) at org.h2.store.LobStorage.removeAllForTable(LobStorage.java:138) at org.h2.store.LobStorage.removeAllForTable(LobStorage.java:147) at org.h2.engine.Database.close(Database.java:1066) at org.h2.engine.Database.removeSession(Database.java:953) at org.h2.engine.Session.close(Session.java:572) at org.h2.jdbc.JdbcConnection.close(JdbcConnection.java:337) at org.aaaStorage.close(MatDbStorage.java:316) at h2perftest.Main.main(Main.java:29) 29/1563 (1%): at org.h2.store.Data.readVarLong(Data.java:1097) at org.h2.store.Data.readValue(Data.java:639) at org.h2.index.PageDataLeaf.readRow(PageDataLeaf.java:598) at org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:329) at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:97) at org.h2.index.PageDataCursor.next(PageDataCursor.java:49) at org.h2.index.IndexCursor.next(IndexCursor.java:235) at org.h2.table.TableFilter.next(TableFilter.java:352) at org.h2.command.dml.Select.queryFlat(Select.java:513) at org.h2.command.dml.Select.queryWithoutCache(Select.java:614) at org.h2.command.dml.Query.query(Query.java:269) at org.h2.command.dml.Query.query(Query.java:239) at org.h2.command.dml.Query.query(Query.java:37) at org.h2.command.CommandContainer.query(CommandContainer.java:78) at org.h2.command.Command.executeQuery(Command.java:181) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java: 96) at org.h2.store.LobStorage.removeAllForTable(LobStorage.java:138) at org.h2.engine.Database.close(Database.java:1066) at org.h2.engine.Database.removeSession(Database.java:953) at org.h2.engine.Session.close(Session.java:572) at org.h2.jdbc.JdbcConnection.close(JdbcConnection.java:337) at org.aaaStorage.close(MatDbStorage.java:316) at h2perftest.Main.main(Main.java:29) 26/1563 (1%): at org.h2.value.Value.getMemory(Value.java:193) at org.h2.result.Row.getMemory(Row.java:117) at org.h2.index.PageDataLeaf.memoryChange(PageDataLeaf.java:576) at org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:355) at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:97) at org.h2.index.PageDataCursor.next(PageDataCursor.java:49) at org.h2.index.IndexCursor.next(IndexCursor.java:235) at org.h2.table.TableFilter.next(TableFilter.java:352) at org.h2.command.dml.Select.queryFlat(Select.java:513) at org.h2.command.dml.Select.queryWithoutCache(Select.java:614) at org.h2.command.dml.Query.query(Query.java:269) at org.h2.command.dml.Query.query(Query.java:239) at org.h2.command.dml.Query.query(Query.java:37) at org.h2.command.CommandContainer.query(CommandContainer.java:78) at org.h2.command.Command.executeQuery(Command.java:181) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java: 96) at org.h2.store.LobStorage.removeAllForTable(LobStorage.java:138) at org.h2.store.LobStorage.removeAllForTable(LobStorage.java:147) at org.h2.engine.Database.close(Database.java:1066) at org.h2.engine.Database.removeSession(Database.java:953) at org.h2.engine.Session.close(Session.java:572) at org.h2.jdbc.JdbcConnection.close(JdbcConnection.java:337) at org.aaaStorage.close(MatDbStorage.java:316) at h2perftest.Main.main(Main.java:29) packages: 63%: org.h2.store 22%: org.h2.value 4%: org.h2.index 4%: org.h2.expression . BUILD SUCCESSFUL (total time: 25 seconds) Regards, wburzyns -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
