I have the web and tcp server running. From java (scala really) I make a
connection with jdbc:h2:tcp://localhost/. Is it also possible to retrieve a
query from a bash script? Like it can be done with mySQL. I could of-course
call a java program, but this would have a lot of overhead. So I was
wonde
The Shell or the RunScript tool should do the job.
http://h2database.com/html/tutorial.html#command_line_tools
--
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
2013/4/14 Noel Grandin
> The Shell or the RunScript tool should do the job.
>
> http://h2database.com/html/tutorial.html#command_line_tools
>
I'll look into it. But in this way I start a jvm. That is quite expensive I
think. There is not a better way?
--
Cecil Westerhof
--
You received this
2013/4/14 Cecil Westerhof
> 2013/4/14 Noel Grandin
>
>> The Shell or the RunScript tool should do the job.
>>
>> http://h2database.com/html/tutorial.html#command_line_tools
>>
>
> I'll look into it. But in this way I start a jvm. That is quite expensive
> I think. There is not a better way?
>
I
Hi,
On a number of occasions I have found that replacing LEFT JOIN with
INNER JOIN dramatically improved poorly performing queries. Generally
the queries I run are generated so it was more convenient to use LEFT
JOIN but depending on various criteria I have been able to use inner
joins where it is
Hi,
Is it possible to clear the query cache? For the purposes of comparing
query performance.
Even restarting the database does not seem to work, so they must be
getting cached to disk,
thanks,
Mike
--
You received this message because you are subscribed to the Google Groups "H2
Database" gr
On 2013-04-14 21:06, Cecil Westerhof wrote:
I'll look into it. But in this way I start a jvm. That is quite
expensive I think. There is not a better way?
How exactly do you think H2 works?
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
T
- What version are you testing on?
Would be great if you could test with the nightly build because I made
some index selection improvements recently.
- What does your DB URL look like?
- Can you do an EXPLAIN on both variants and post the results here?
Regards, Noel Grandin
--
You received