db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrew McIntyre <fuzzylo...@nonintuitive.com>
Subject Re: alligned Vs Non Alligned log writes ..
Date Thu, 09 Dec 2004 01:25:49 GMT

On Dec 3, 2004, at 4:36 PM, Suresh Thalamati wrote:

> It would be great if  some one can run this test on other platforms and
> post the results to the list.

AIX 5.2, IBM JDK 1.4.2, 1 GHz Power4, only marginal differences in 
times. full results:
(Buffer-Size(K) | Alligned Write(msec) |NonAlligned Write(msec))

512 |  15.3046875  |  15.9609375
256 |  10.7109375  |  11.578125
128 |  8.328125  |  8.640625
64 |  7.234375  |  7.4296875
32 |  6.59375  |  6.78125
16 |  6.328125  |  6.4921875
12 |  6.3515625  |  6.40625
10 |  6.3125  |  6.359375
8 |  6.1875  |  6.359375
6 |  6.2421875  |  6.3125
4 |  6.1171875  |  6.265625
2 |  6.078125  |  6.2109375
1 |  6.0703125  |  6.171875

Solaris 9, Sun JDK 1.4.2_03, Sparc II class CPU of unknown speed, 
significant increase in speed for certain values, esp. 4, 8, 16. full 
results:

512 |  578.3046875  |  586.796875
256 |  289.1171875  |  297.1484375
128 |  144.1875  |  153.21875
64 |  72.09375  |  81.3359375
32 |  36.0859375  |  44.6171875
16 |  18.046875  |  26.7109375
12 |  17.7265625  |  22.09375
10 |  18.1484375  |  19.8046875
8 |  9.1953125  |  17.59375
6 |  13.0546875  |  15.25
4 |  8.7265625  |  13.171875
2 |  8.5625  |  10.7578125
1 |  8.4765625  |  9.6484375

And just for fun, Mac OS X 10.3.5, JDK 1.4.2, rwd mode (not rws, of 
course), 466 Mhz G4, aligned writes faster in most cases, sometimes by 
a large margin, except at 512 block size, where there is a significant 
performance penalty. full results:

512 |  70.5859375  |  42.453125
256 |  9.8203125  |  22.1328125
128 |  3.6953125  |  7.0390625
64 |  1.28125  |  4.28125
32 |  0.3515625  |  1.8828125
16 |  0.1171875  |  0.109375
12 |  0.09375  |  0.1015625
10 |  0.0703125  |  0.078125
8 |  0.0546875  |  0.0625
6 |  0.2265625  |  0.046875
4 |  0.03125  |  0.0390625
2 |  0.03125  |  0.03125
1 |  0.03125  |  0.0234375

andrew


Mime
View raw message