I tried by adding commit in the test method
populateData();
sharedConnection.commit();
But results are still the same:
- when run in memory - 1500ms
- when not run in memory - 426ms
On Dec 7, 12:21 pm, Noel Grandin <[email protected]> wrote:
> you are never calling commit on the connection
>
>
>
>
>
>
>
> On Wed, Dec 7, 2011 at 19:07, Vinod <[email protected]> wrote:
> > I would appreciate any help on this, as I am not able to make use of
> > H2 because of this pretty basic issue.
>
> > On Nov 22, 12:43 pm, Vinod <[email protected]> wrote:
> >> I have a query which is taking more time when executed in memory.
>
> >> 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 stats:
> >> 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
>
> >> I have created the sample java program(http://www.4shared.com/file/
> >> TdVngWtZ/ImdbInMemoryPerfVsNonInMemoryP.html) with sample data. The
> >> program is self explanatory and is following the steps as mentioned
> >> above.
>
> >> Kindly help me on what am I missing here.
> >> In the actual application where I am trying to use IMDB, similar query
> >> when executed in memory takes 2500ms, and non-inmemory takes 170ms.
>
> > --
> > 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
> > athttp://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.
