Hi, Could you run EXPLAIN SELECT ... and then post the query plan? See http://www.h2database.com/html/grammar.html#explain
How many rows are in the result set? Maybe you need to create an index on DATA? Another idea is to use a UNION instead of 1 = THIS.KONTO_Z_ID_KONTO_OID OR 1 = THIS.KONTO_NA_ID_KONTO_OID)) Regards, Thomas On Thu, Dec 25, 2008 at 10:08 PM, www.ePortfel.com <[email protected]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
