Hi, By default, Oracle uses a lot more (cache) memory than H2. Another problem could be that an index is not used (did you run ANALYZE?). Without more details I'm afraid it is not possible to say what the problem could be. I suggest to analyze the problem yourself first:
http://www.h2database.com/html/performance.html#application_profiling http://www.h2database.com/html/performance.html#database_performance_tuning If this doesn't help, could you create a simple standalone test case so we can understand and reproduce the problem? Regards, Thomas
-- 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.
