On 2013-07-17 19:51, cowwoc wrote:
I am referring to the fact that currently if I want to process N
rows, you need to create N * PreparedStatements (one per row inside
fire()) as opposed to once at the beginning of the transaction. You
are right that this needs to be benchmarked.
One cha
Hi all,
I've been using H2 in production on a small server without any problems.
I'm thinking about using it again in another application. I did a search in
the mailing list for database corruption. It looks there there have been
some reports of data corruptions, some of which were followed by fix
Hi Thomas,
I thought the same, I thought it could be a bug in my application.
Then I restored my latest backup file by using the web interface of H2 by
clicking on "Tools" -> "Restore" -> "Start".
And the result was the same: Trace-output of error messages in
trace.db-file even if I remove the t
I can say that the approach with VARCHARs works ok in my case after several
months of test/production usage. I'm using up to 10K length VARCHARs.
On Tuesday, March 5, 2013 2:18:21 AM UTC+2, Kartweel wrote:
>
> It depends on your use case I think. I recently had 10MB objects reading
> into memory
If you look inside the zip file of your backup are there trace files in
there?
On 18/07/2013 4:14 PM, EDV-Services wrote:
Hi Thomas,
I thought the same, I thought it could be a bug in my application.
Then I restored my latest backup file by using the web interface of H2
by clicking on "Tools"
Hi,
I have experienced a strange behaviour in H2 1.3.172
CREATE TABLE X (
num INT,
str VARCHAR(50)
);
INSERT INTO X VALUES(10, 'aaa');
INSERT INTO X VALUES(20, 'xxx');
SELECT x.str, x.num FROM X x WHERE num > 0
UNION
SELECT x.str, x.num FROM X x WHERE num > 1
ORDER BY *x.*num;
DROP TABLE X;
It's expected.
When you do a UNION, the resulting "thing" no longer has table names in
scope, only column names.
On 2013-07-18 11:53, Kornel wrote:
CREATE TABLE X (
num INT,
str VARCHAR(50)
);
SELECT x.str, x.num FROM X x WHERE num > 0
UNION
SELECT x.str, x.num FROM X x WHERE num > 1
ORDE
Thanks for the quick response, makes perfect sense. I was deceived by T-SQL
and previous h2 versions which allows such queries (I'm doing an upgrade
right now from)
Kornel
W dniu czwartek, 18 lipca 2013 11:59:45 UTC+2 użytkownik Noel Grandin
napisał:
>
> It's expected.
>
> When you do a UNION
view is slower than the actual query,Please help me on how to increase the
performance of the view
--
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+un
On 18/07/2013 3:13 AM, Noel Grandin wrote:
On 2013-07-17 19:51, cowwoc wrote:
I am referring to the fact that currently if I want to process N
rows, you need to create N * PreparedStatements (one per row inside
fire()) as opposed to once at the beginning of the transaction. You
are right
I was trying to see if there's room enough to provide a patch for H2... in
order to use Eclipse I've seen I have to create a new project, copy
settings, run the custom script in order to download the necessary deps and
configure them into the project...
It is all feasible with no problems, but I
11 matches
Mail list logo