Hi,
Makes sense to me. If cpu isn't the issue (which I doubt it would be in
a database, but maybe the encryption adds a lot of overhead?) then
adding more threads would increase the time proportionally +
synchronisation overhead. Also there would be more work for the disk
seeking between all the different locations.
So are you saying that disk io is increasing with each thread you add?
or is it capped? both bandwidth and iops ?
On 3/11/2012 4:44 AM, Sri wrote:
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
<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
<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.
--
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.
