Is it CPU bound or disk bound during that 90 seconds when the query is
running?
You can try increasing JVM memory?
The the slow query the same as all the others?. perhaps it isn't using
an index for that query?
You really need to try and find out what is going on, or get it running
in a test environment where you can reproduce the issue and find out
what it is, or profile it.
On 19/09/2014 7:27 PM, Arun wrote:
On Wednesday, September 17, 2014 12:14:32 AM UTC+5:30, Thomas Mueller
wrote:
Hi,
and jar version is h2-1.1.114.jar.
Hm, that's very very old. Could you upgrade to a more recent version?
jdbc:h2:/data/Testbed/h2DB/Arun;DB_CLOSE_ON_EXIT=FALSE;FILE_LOCK=NO;LOG=2
I hope you understand that FILE_LOCK=NO is very dangerous.
Regards,
Thomas
Hi Sir,
As its a production server.running from past few years.its impossible
to change jar version.
if jar version is same then anything which we can try..?
we can recreate DB.
we can change DBURL. any appropriate DB parameter which we can use
with same version jar.
--
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...@googlegroups.com
<mailto:h2-database+unsubscr...@googlegroups.com>.
To post to this group, send email to h2-database@googlegroups.com
<mailto:h2-database@googlegroups.com>.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
--
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...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.