Hi Andrei,
The one with the 800MB heap was my initial test case, the 4MB row size was
just an example to clarify my problem.
Unfortunately, creating the indexes in an adminstrative mode is not a
solution for us.
H2 is just used as a temporary database helping us to bring together data
from
This could be another optimization, but that wont help if I have a table
with millions of rows and an assumed column width of 4MB of data.
With 4 GB heap, any value of MAX_MEMORY_ROWS > 1000 will lead to OOM Error
when selecting from that table.
And a value of 1000 might not be high enough for
Hi Noel,
our users typically deal with huge amounts of data, which often do not fit
into memory. Tables might have hundreds of columns, so that already a low
amount of rows held in memory can occupy a lot of it.
Additionally, queries are often issued in parallel, therefore a low value
was set
Just tested the fix.
Works perfectly, thanks.
Mit freundlichen Grüßen
Christoff Schmitz
F I N A R I S
Financial Software Partner GmbH
Sömmerringstrasse 23
60322 Frankfurt am Main
Fon: +49 (0)69 / 254 98 - 24
Mobile: +49 (0)176 / 206 34 186
Fax: +49 (0)69 / 254 98 - 50
eMail
I am out of the office until 02.01.2018.
I will reply to your message when I return.
Note: This is an automated response to your message "[h2] Re: USE INDEX
confusion with joins, v1.4.195" sent on 23.12.2017 1:25:19 PM.
This is the only notification you will receive while this person is
Unfortunately, H2 does not treat (1) as array.
The same problem occurs when casting an integer to array:
cast(1 as ARRAY) results in a single element array containing the String
'1'.
From: IanP i.pri...@surveybe.com
To: h2-database@googlegroups.com
Date: 2015-07-10 16:02
Subject:
Hi,
Is there a specific reason why the expression
CAST(5 AS ARRAY)
results in an array containing a VARCHAR value instead of a numeric value?
Or might this be a bug?
Kind regards,
Christoff Schmitz
versions is equal, but using the table
function, only the single statements must fit into memory, but not the
full cascade of SelectUnion objects.
Maybe there is a possibility to updates H2's handling of UNION ALL
statements so that they require less memory?
Kind regards
Christoff Schmitz
Hi,
org.h2.tools.TriggerAdapter (your Trigger should extend that class),
provides the protected members schemaName and tableName.
Kind regards
Christoff Schmitz
F I N A R I S
Financial Software Partner GmbH
Sömmerringstrasse 23
60322 Frankfurt am Main
Fon: +49 (0)69 / 254 98 - 24
, not 1 as numeric type
Kind regards
Christoff Schmitz
F I N A R I S
Financial Software Partner GmbH
Sömmerringstrasse 23
60322 Frankfurt am Main
Fon: +49 (0)69 / 254 98 - 24
Mobile: +49 (0)176 / 206 34 186
Fax: +49 (0)69 / 254 98 - 50
eMail:mailto:christoff.schm...@finaris.de
www
),
1)
Kind regards,
Christoff Schmitz
F I N A R I S
Financial Software Partner GmbH
Sömmerringstrasse 23
60322 Frankfurt am Main
Fon: +49 (0)69 / 254 98 - 24
Mobile: +49 (0)176 / 206 34 186
Fax: +49 (0)69 / 254 98 - 50
eMail:mailto:christoff.schm...@finaris.de
www: http
.
Seems a bit buggy to me.
Currently, my only workaround is setting the member public static
JavaObjectSerializer serialize of class Utils directly from my
application (H2 is used as embedded database).
Kind regards,
Christoff Schmitz
F I N A R I S
Financial Software Partner GmbH
Sömmerringstrasse
() line: 32
Engine.clinit() line: 29 [local variables unavailable]
[...]
Kind regards,
Christoff Schmitz
F I N A R I S
Financial Software Partner GmbH
Sömmerringstrasse 23
60322 Frankfurt am Main
Fon: +49 (0)69 / 254 98 - 24
Mobile: +49 (0)176 / 206 34 186
Fax: +49 (0)69
In this case the documentation is wrong as ResultSet.getObject() returns
an array.
Kind regards
Christoff Schmitz
F I N A R I S
Financial Software Partner GmbH
Sömmerringstrasse 23
60322 Frankfurt am Main
Fon: +49 (0)69 / 254 98 - 24
Mobile: +49 (0)176 / 206 34 186
Fax: +49 (0)69
on that column returns an Object[] as
expected).
Kind regards,
Christoff Schmitz
F I N A R I S
Financial Software Partner GmbH
Sömmerringstrasse 23
60322 Frankfurt am Main
Fon: +49 (0)69 / 254 98 - 24
Mobile: +49 (0)176 / 206 34 186
Fax: +49 (0)69 / 254 98 - 50
eMail
IN (16,17,18)
)
WHERE
ZEILE_RELATIV = 17
Kind regards
Christoff Schmitz
F I N A R I S
Financial Software Partner GmbH
Sömmerringstrasse 23
60322 Frankfurt am Main
Fon: +49 (0)69 / 254 98 - 24
Mobile: +49 (0)176 / 206 34 186
Fax: +49 (0)69 / 254 98 - 50
eMail
.command.dml.Query.query(Query.java:323)
at org.h2.command.dml.Query.query(Query.java:291)
at org.h2.command.dml.Query.query(Query.java:37)
at org.h2.command.CommandContainer.query(CommandContainer.java:91)
at org.h2.command.Command.executeQuery(Command.java:197)
... 22 more
Kind regards,
Christoff Schmitz
jdbc:h2:file:PATH;MULTI_THREADED=1;DB_CLOSE_DELAY=-1;LOG=0;UNDO_LOG=0
;QUERY_CACHE_SIZE=0;CACHE_SIZE=16384
The database is only required during runtime of my application.
Therefore undo and transaction log are disabled to improve performance.
Kind regards,
Christoff Schmitz
F I N A R I S
num NOT IN (-1,-5)
Kind regards
Christoff Schmitz
F I N A R I S
Financial Software Partner GmbH
Sömmerringstrasse 23
60322 Frankfurt am Main
Fon: +49 (0)69 / 254 98 - 24
Mobile: +49 (0)176 / 206 34 186
Fax: +49 (0)69 / 254 98 - 50
eMail:mailto:christoff.schm...@finaris.de
www
) {
session.addLocalTempTableIndex(index);
} else {
database.addSchemaObject(session, index);
}
}
indexes.add(index);
setModified();
return index;
}
Kind regards
Christoff Schmitz
F I N A R I S
Financial Software Partner GmbH
).
If one index creation thread waits longer than the specified LOCK_TIMEOUT,
then Timeout trying to lock table SYS is thrown.
My current workaround is to set the LOCK_TIMEOUT to Integer.MAX_VALUE.
Kind regards
Christoff Schmitz
F I N A R I S
Financial Software Partner GmbH
Sömmerringstrasse 23
60322
);
return connection;
}
}
Kind regards,
Christoff Schmitz
F I N A R I S
Financial Software Partner GmbH
Sömmerringstrasse 23
60322 Frankfurt am Main
Fon: +49 (0)69 / 254 98 - 24
Mobile: +49 (0)176 / 206 34 186
Fax: +49 (0)69 / 254 98 - 50
eMail:mailto:christoff.schm
in interval
]-1, 1[
Can you tell me if this is already fixed for a later version of the 1.3
branch?
Kind regards
Christoff Schmitz
F I N A R I S
Financial Software Partner GmbH
Sömmerringstrasse 23
60322 Frankfurt am Main
Fon: +49 (0)69 / 254 98 - 24
Mobile: +49 (0)176 / 206 34 186
Fax
)
at org.h2.command.dml.Query.query(Query.java:284)
at org.h2.command.dml.Query.query(Query.java:36)
at org.h2.command.CommandContainer.query(CommandContainer.java:91)
at org.h2.command.Command.executeQuery(Command.java:195)
... 156 more
Kind regards,
Christoff Schmitz
F I N A R I S
Financial
The result is the same for 1.3.176
Kind regards
Christoff Schmitz
F I N A R I S
Financial Software Partner GmbH
Sömmerringstrasse 23
60322 Frankfurt am Main
Fon: +49 (0)69 / 254 98 - 24
Mobile: +49 (0)176 / 206 34 186
Fax: +49 (0)69 / 254 98 - 50
eMail:mailto:christoff.schm
Christoff Schmitz
F I N A R I S
Financial Software Partner GmbH
Sömmerringstrasse 23
60322 Frankfurt am Main
Fon: +49 (0)69 / 254 98 - 24
Mobile: +49 (0)176 / 206 34 186
Fax: +49 (0)69 / 254 98 - 50
eMail:mailto:christoff.schm...@finaris.de
www: http://www.finaris.de und http
Session.prepareLocal(String) line: 428
Session.prepareCommand(String, int) line: 377
JdbcConnection.prepareCommand(String, int) line: 1138
JdbcStatement.executeQuery(String) line: 72
[...]
Kind regards
Christoff Schmitz
F I N A R I S
Financial Software
to the disk drive. While H2 has one database file, Apache Derby has
one per Table or Index.
Since the H2 file is growing to some GB of size, I would assume that this
is the problem.
I will try to create a small java program as test case for you within the
next days.
Kind regards,
Christoff
to be the same.
Is there anything known about this problem (reason, workaround, fix)?
Thanks in advance and kind regards,
Christoff Schmitz
F I N A R I S
Financial Software Partner GmbH
Sömmerringstrasse 23
60322 Frankfurt am Main
Fon: +49 (0)69 / 254 98 - 24
Mobile: +49 (0)176 / 206 34
to getResultSet()
call to getResultSet()
Kind regards and thanks in advance
Christoff Schmitz
F I N A R I S
Financial Software Partner GmbH
Sömmerringstrasse 23
60322 Frankfurt am Main
Fon: +49 (0)69 / 254 98 - 24
Mobile: +49 (0)176 / 206 34 186
Fax: +49 (0)69 / 254 98 - 50
eMail
()
call to getResultSet()
call to getResultSet()
call to getResultSet()
call to getResultSet()
Kind regards and thanks in advance
Christoff Schmitz
F I N A R I S
Financial Software Partner GmbH
Sömmerringstrasse 23
60322 Frankfurt am Main
Fon: +49 (0)69 / 254 98 - 24
Mobile: +49 (0
.
Regards,
Christoff Schmitz
F I N A R I S
Financial Software Partner GmbH
Sömmerringstrasse 23
60322 Frankfurt am Main
Fon: +49 (0)69 / 254 98 - 24
Mobile: +49 (0)176 / 206 34 186
Fax: +49 (0)69 / 254 98 - 50
eMail:mailto:christoff.schm...@finaris.de
www: http://www.finaris.de
.
Is there a possibility to limit that cache size?
Regards,
Christoff Schmitz
F I N A R I S
Financial Software Partner GmbH
Sömmerringstrasse 23
60322 Frankfurt am Main
Fon: +49 (0)69 / 254 98 - 24
Mobile: +49 (0)176 / 206 34 186
Fax: +49 (0)69 / 254 98 - 50
eMail:mailto:christoff.schm
,
Christoff Schmitz
F I N A R I S
Financial Software Partner GmbH
Sömmerringstrasse 23
60322 Frankfurt am Main
Fon: +49 (0)69 / 254 98 - 24
Mobile: +49 (0)176 / 206 34 186
Fax: +49 (0)69 / 254 98 - 50
eMail:mailto:christoff.schm...@finaris.de
www: http://www.finaris.de und http
34 matches
Mail list logo
