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].
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.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
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.
