Disk IO looks good too...can't seem to find what is the issue... On Thursday, November 1, 2012 2:36:21 PM UTC-7, Kartweel wrote: > > How about disk io?, usually the disk is the bottleneck. > > On 2/11/2012 3:44 AM, Sri wrote: > > Hi, > > > > I am running H2 DB in server mode and using it for read only. It's > > been performing very good with single user/thread and the performance > > is getting degraded as I add more concurrent users/threads. > > > > Single user/thread --> about 100ms > > 10 users/threads --> about 230ms > > 15 users/threads --> about 320ms > > 20 users/threads --> about 440ms > > 25 users/threads --> about 550ms > > 40 users/threads --> about 900-1000ms > > 50 users/threads --> about 1300-1400ms > > > > Please see the attached screenshot for CPU, heap and thread > > monitoring. I do not see the problem of CPU being max out or not > > enough memory or not scaling threads as I add more users. > > > > H2 Version:h2-1.3.166 > > Url: > > jdbc:h2:tcp://localhost:9092/<<DB absolute > > > path>>;MULTI_THREADED=1;CACHE_SIZE=<<cashesize>>;CIPHER=AES;IFEXISTS=TRUE > > > > <<cashesize>> ==> tried different values, defualt-16mb, 128mb, 256mb, > > 512mb and 1024mb (supplied in KB though) > > > > FYI, > > Each thread is executing lot of queries (around 15-20) and some of > > them are recursive queries (to fetch heirachy data). > > > > > > Please let me know if anybody run into the same problem and how did > > you resolve. > > > > Thanks in advance. > > -Sri > > -- > > You received this message because you are subscribed to the Google > > Groups "H2 Database" group. > > To view this discussion on the web visit > > https://groups.google.com/d/msg/h2-database/-/hbZ9WV8cFWEJ. > > To post to this group, send email to > > [email protected]<javascript:>. > > > To unsubscribe from this group, send email to > > [email protected] <javascript:>. > > For more options, visit this group at > > http://groups.google.com/group/h2-database?hl=en. > > >
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/njQ5VJHkPvEJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
