Here is my url:
jdbc:h2:./mydb;DB_CLOSE_ON_EXIT=FALSE;DB_CLOSE_DELAY=-1;MULTI_THREADED=1;QUERY_CACHE_SIZE=100;MAX_LOG_SIZE=64;MAX_COMPACT_TIME=5000;LOCK_MODE=3;LOCK_TIMEOUT=10000;DEFRAG_ALWAYS=TRUE;MVCC=TRUE;CACHE_TYPE=SOFT_LRU
i will work on a test case. It would essentially be a bunch of threads all
doing:
JDOQLTypedQuery<some_table> tq = pm.newJDOQLTypedQuery(some_table.class);
Qsome_table candidate = Qsome_table.candidate();
List<some_table> results = tq.filter(candidate.some_id.eq(an_id)).executeList();
some_table would look like:
@PersistenceCapable(detachable = "true")
public class some_table {
@PrimaryKey
@Persistent(valueStrategy = IdGeneratorStrategy.UUIDHEX)
private String id;
@Persistent
@Index
@Column(length = 48)
private String some_id;
... more fields
}
On Friday, February 10, 2017 at 11:27:30 AM UTC-7, Noel Grandin wrote:
>
> hmmm, what does your DB url look like?
> And do you have a standalone test case?
>
> I think it's pretty cool that we manage to get that low down in our stack
> before hitting a bottleneck ;-)
> We could perhaps be using a reader/writer lock there.
>
>
--
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 https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
