Hi,
I guess the second query is much faster because it only needs to read from
the index (as only the indexed column is referenced). The first query needs
to read the row itself (H2 always reads the whole row), that's why it is
slower.
Regards,
Thomas
On Monday, March 19, 2012, Peter Yuill
Hi,
The main class is TableFilter.
Regards,
Thomas
On Sunday, March 25, 2012, Tharindu Jayasinghe wrote:
Hey Thomas,
Thanks for the information. Could you just let me know where I can find
these classes in the code.
Regards,
Tharindu.
--
You received this message because you are
Hi,
Was it really such a long running query, or was the system date or
time changed while running it?
(probably the System.currentTimeMillis() needs to be replaced with
System.nanoTime())
Regards,
Thomas
On Tue, Mar 27, 2012 at 2:14 PM, Noel Grandin noelgran...@gmail.com wrote:
Wow, that is
See http://code.google.com/p/h2database/issues/detail?id=388
On Tue, Mar 27, 2012 at 11:47 AM, ga calis cali...@gmail.com wrote:
General error: java.lang.ArrayIndexOutOfBoundsException:
0 [5-164] HY000/5 (Help)
org.h2.jdbc.JdbcSQLException: General error:
I believe I understand the the cause of the hang. I investigated the
simplest case of using a h2.serverResultSetFetchSize value of 600,
which is greater than the 523 rows I know that I have. As I mentioned,
I can retrieve the first 3 rows (single CLOB column) okay and then I
either hang on the
I believe I understand the the cause of the hang. I investigated the
simplest case of using a h2.serverResultSetFetchSize value of 600, which is
greater than the 523 rows I know that I have. As I mentioned, I can
retrieve the first 3 rows (single CLOB column) okay and then I either hang
on
Hi,
I don't know what the problem could be. There are two thread on the
server side that are waiting for a client, here:
private void process() throws IOException {
int operation = transfer.readInt(); == server
switch (operation) {
case SessionRemote.SESSION_PREPARE: {
Hi Thomas,
No there are no other clients involved, however I am using multiple statements
in the same transactions. All connections are made from the application running
inside the same VM. There are no remote connections.
Thanks for taking a look. I am a little confused myself as this only