Hi Andrei, I created a standalone test case. I wrote a simple Java application that can be executed from the command line.
You can download the application from here: https://www.dropbox.com/sh/3mgnl310ltum389/AAA8Km-ggSQpXXiktyP6lfbHa?dl=0. In the zip file you will find the file h2Standalone.jar that you need to execute in order to generate a h2 data base as a file and insert a big amount of data in a table. In the zip file you will find also the h2 jar that I built from the sources last week. Remove the suffixes '.removeme' before executing the jar below. Extract both jars in some folder and execute from there the following commands: 1. java -jar h2Standalone.jar -dir "dir1" 2. java -jar h2Standalone.jar -dir "dir2" -mvstore The first command creates a h2 data base with PgStore, wehreas the second one a h2 data base with MVStore. dir1 and dir2 are the absolute paths to existing directories and they must be different. Note that dir1 and dir2 must be existing directories, otherwise the application will terminate with an error. Both commands create a table named "TableB" and insert in this table nearly 306 000 items. The command 'java -jar h2Standalone.jar -help' gives also hints how the application should be called. Note that -mvstore must be at the end of the command. I used Squirl to test the execution times of "SELECT * FROM TableB" on both generated data bases. For the current h2 driver the execution times for selecting all items with PgStore are 2 times faster than with MVStore. In case you want to execute the test case with a newer version of h2 you can just change the h2.jar file in the directory where h2standalone.jar is placed. If you have questions about how to execute the test case, then don't hesitate to write. I really hope that this test case can help to optimize the executions of select queries in H2. Getting execution times that are 2.5 times faster will improve many tasks in our main application. Thank you in advance! Greetings, Ivaylo Am Donnerstag, 23. August 2018 19:29:05 UTC+2 schrieb Ivaylo Dobrikov: > > Thank you for the response! I will try to create a standalone tests case > next week. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
