Hi, Thanks! The query is really complicated. Could you try to simplify the test case to the bare minimum?
Regards, Thomas On Mon, Jun 18, 2012 at 4:33 PM, Vinod <[email protected]> wrote: > Hi, > > I would appreciate any help on the issue that I am facing where a query is > taking more time when executed in memory. > > Attached is the sample program. > The details are: > Created a table > Created a few extra columns to achieve functional indexes. > Created indexes on these extra columns > Populated data > Executed test query. > > Following are the execution results: > Using the java program, when the query is executed in memory - it takes > 1500ms > Using the java program, when the query is executed not in memory - it takes > 400ms > When using the H2 console in browser(started from java program > using Server.main(null);), the query takes 160ms > > Thanks, > Vinod > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/h2-database/-/K37pjwTydu4J. > 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. -- 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.
