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