Hello folks,
in our firm we are using H2 for our test suite to perform various of
integration tests for our applications. Recently, we updated to H2 1.4.196;
until the day of the update, we used an older version of H2 1.3.166.
We found out that the execution times of some test cases became too
Hi Noel,
thank you for the quick response. I've executed the statetement above with
EXPLAIN ANALYZE in version 1.4 and version 1.3 and couldn't see any
differences in the plan. However, the execution time in 1.4 was
significantly greater than the execution time in 1.3. I am going now to
gener
Hello,
I could generate a test case from our data model which can to some extent
reporduce the behavior of H2 v 1.4 that I mentioned above. I attatched two
SQL scripts. The first one creates the tables with part of the constraints
that the original tables in our test suite have. The second one
Thanks a lot!
Am Dienstag, 24. April 2018 10:25:15 UTC+2 schrieb Noel Grandin:
>
> Hi
>
> Thanks for the excellent test case.
>
> I note that most of the time is being spent in the planning phase of the
> query.
>
> I have just pushed a commit which makes 1.4 about twice as fast as it was
> b
Just to keep you on track.
I built H2 from the source and indeed the execution times of the statements
improved. The times are not as fast as those in 1.3 but we are satisfied.
There are still some test cases that have too huge execution times as they
execute an enormous number of queries. For
Hello,
I recently updated our H2 to version 1.4.197. After the update we observed
that sometimes out application cannot execute some of the SQL statement,
terminating with the following error:
2018-08-19 16:26:25,969 INFO - running processor 388
2018-08-19 16:26:54,713 ERROR - General error:
Hi Andrei,
thank you for the answer. The problem occurs that I report above occurs on
H2 1.4.197/9. H2 1.4.197 is already the latest version of H2 that can be
downloaded from the website.
I will try these days to check out the latest source code and build and
then test again. Do you know which
Hi Andrei,
I built today from the source (latest merge on the master branch 2018-08-21
15:01:11) and we have tested whether the IllegalStateException above occurs
when the newest H2 jar is used. The error does not appear any more.
However, the performance issues are still existing. I compared t
In another discussion I have already mentioned the problem with the huge
execution
times: https://groups.google.com/forum/#!topic/h2-database/Fcj2EKTyb-E
Am Mittwoch, 22. August 2018 18:35:05 UTC+2 schrieb Ivaylo Dobrikov:
>
> Hi Andrei,
>
> I built today from the source (latest merge on the mas
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 h2-database+unsubscr...@googl
Hi Andrei,
I created a standalone test case. I wrote a simple Java application that
can be executed from the command line.
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.
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
Hi Andrei,
today I checked out the latest version of the master branch (
0ff4499b032104e0f83d2d7c5978e5273547a480) and it seems that the latest
build of H2 has resolved the performance issues for MVStore. I am pretty
sure that I built from the latest source code last week and tested the H2
driv
13 matches
Mail list logo