Comparison : mysql-native + asdf and hunt-database + asdf

[Vino]

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