On Saturday, 7 November 2020 at 14:16:46 UTC, Vino wrote:
On Saturday, 7 November 2020 at 12:29:46 UTC, Andre Pany wrote:
On Friday, 6 November 2020 at 04:58:05 UTC, Vino wrote:
[...]

While doing performance measurements you should do each test multiple time (at least 5 times). There could be for example an effect that executing a db query the first time is a lot slower than afterwards.

Maybe mysql native is slower, but maybe this isn't the case, just the way performance measurements was done was incorrectly.

Kind regards
Andre

Hi Andre,

  The benchmark was performed with 100 executions as below

void main()
{
 void f() {
 Array!string[string] data = getdata("TEST");
 foreach(i; data) { writeln(i[]); }
 }
 auto r = benchmark!(f)(100);
 Duration t = r[0];
 writeln(t);
}

Hi All,

Upon further testing, below are the observations, based on different compliers (DMD/LDC), using LDC the size of the executable is reduced but the run time is increased from 5 to 6 sec , the document states that if we use the complier option dub --"build=release --compiler=ldmd2" it would enhance the performance but as per our analysis we do not see and improvement, below is the runtime

LDC : 6 secs, 136 ms, 97 μs, and 3 hnsecs LDC(dub --build=release --compiler=ldmd2): 6 secs, 203 ms, 283 μs, and 6 hnsecs


Observations
********************
Component       :  mysql-native + asdf  
Complier        :  DMD
Size            :  17MB
Duration        :  10 secs, 189 ms, 919 μs, and 3 hnsecs

Component       :  mysql-native + asdf  
Complier        :  LDC
Size            :  20MB
Duration        :  10 secs, 526 ms, 350 μs, and 6 hnsecs

Component       :  mysql-native + asdf  
Complier        :  LDC(dub --build=release --compiler=ldmd2)
Size            :  3.7MB
Duration        :  10 secs, 411 ms, 793 μs, and 8 hnsecs
*************************************************************
Component       :  hunt-database + asdf 
Complier        :  DMD
Size            :  81MB
Duration        :  5 secs, 916 ms, 418 μs, and 3 hnsecs

Component       :  hunt-database + asdf 
Complier        :  LDC
Size            :  50MB
Duration        :  6 secs, 136 ms, 97 μs, and 3 hnsecs

Component       :  hunt-database + asdf 
Complier        :  LDC(dub --build=release --compiler=ldmd2)
Size            :  17MB
Duration        :  6 secs, 136 ms, 97 μs, and 3 hnsecs

From,
Vino.B

Reply via email to