Re: Multi-threaded DB creation (was: svn commit: r1139851 - /ofbiz/trunk/framework/entity/src/org/ofbiz/entity/jdbc/DatabaseUtil.java)

[Adrian Crum <ad...@sandglass-software.com>]

On the other hand, I tried -1 and 2 settings on an 4 CPU system with a 
single hard disk and they made no difference.

-Adrian

On 6/26/2011 10:32 PM, Adrian Crum wrote:
> A setting of -2 on my dual-CPU, high speed RAID array development 
> machine resulted in a measurable reduction in table creation time. 
> Good job!
>
> -Adrian
>
> On 6/26/2011 9:43 PM, Adam Heath wrote:
>> On 06/26/2011 03:41 PM, Adrian Crum wrote:
>>> What would +2 do? Or is the multiplier an absolute value?
>>
>> 0=1
>> 1=1
>> 2=2
>> 3=3
>> -1=abs(-1)*num-cpus
>> -2=abs(-2)*num-cpus
>> -5=abs(-5)*num-cpus
>>
>> and so on.

Re: Multi-threaded DB creation

[Adam Heath <do...@brainfood.com>]

On 06/30/2011 08:49 AM, Adrian Crum wrote:
> On the other hand, I tried -1 and 2 settings on an 4 CPU system with a
> single hard disk and they made no difference.

How much L2-cache on the cpu(s) was there?  Java quite often is larger 
than the L2-cache, which then means it's waiting on slower memory.

> On 6/26/2011 10:32 PM, Adrian Crum wrote:
>> A setting of -2 on my dual-CPU, high speed RAID array development
>> machine resulted in a measurable reduction in table creation time.
>> Good job!
>>
>> -Adrian
>>
>> On 6/26/2011 9:43 PM, Adam Heath wrote:
>>> On 06/26/2011 03:41 PM, Adrian Crum wrote:
>>>> What would +2 do? Or is the multiplier an absolute value?
>>>
>>> 0=1
>>> 1=1
>>> 2=2
>>> 3=3
>>> -1=abs(-1)*num-cpus
>>> -2=abs(-2)*num-cpus
>>> -5=abs(-5)*num-cpus
>>>
>>> and so on.