Thanks Ewald and Thomas. I tried my scenario by increasing the cache size and it the result were comparable to other databases and in some case H2 performed better. Thanks a lot
On Jan 12, 1:03 am, Thomas Mueller <[email protected]> wrote: > 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_profilinghttp://www.h2database.com/html/performance.html#database_performance_... > > 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.
