This is really strange. I began profiling the query using NetBeans. After that when I run the code it runs fast. It runs fast when I run it from NetBeans or debug it from NetBeans unless I set breakpoint onto stmt.execute() - in that case it runs slowly.
So maybe it depends on how the system loads files or so? It behaves differently depending on if the breakpoint is set or not. The db files have 15MB of size. I use H2 version 1.0.79. Under this link: http://marinamokotow.12volt.home.pl/marinamokotow/h2perf.png I have put the result of profiling. It looks like TableFilter iteration eates most of the time. It is invoked 10000 times. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
