Hi Noel, 

    I am not sure about the problems with LOG/UNDO_LOG=0, I will remove 
these and verify the issue. 

    I am going to use the following URL, please advice any other changes 
would required. 

    
 
jdbc:h2:file:var/cache/10020/h2/mydb;TRACE_LEVEL_FILE=0;TRACE_LEVEL_SYSTEM_OUT=0;MAX_MEMORY_ROWS=10000;MAX_OPERATION_MEMORY=10000;

Thanks,
Suresh

On Friday, April 17, 2015 at 2:03:07 PM UTC+5:30, Noel Grandin wrote:
>
>
>
> On 2015-04-17 10:18 AM, suresh kumar wrote: 
> > 
> >     Database URL: 
> > 
> jdbc:h2:file:var/cache/10020/h2/mydb;LOG=0;LOCK_MODE=0;UNDO_LOG=0;FILE_LOCK=NO;TRACE_LEVEL_FILE=0;TRACE_LEVEL_SYSTEM_OUT=0;MAX_MEMORY_ROWS=100;MAX_OPERATION_MEMORY=100;
>  
>
> > 
>
> Did you read the many emails and documentation where we say that if you 
> use LOG=0 or UNDO_LOG=0 we don't care about your 
> problems? 
>
> And you are severely damaging your performance with those MAX_ settings. 
>

-- 
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to