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

2020-11-07 Thread frame via Digitalmars-d-learn
On Sunday, 8 November 2020 at 05:07:54 UTC, frame wrote: Something wrong with this library. Well, we need an edit function here. The library has no TCP_NODELAY flag enabled. This fix speeds it up to 10x and solves the 44ms problem to 400us https://github.com/mysql-d/mysql-native/pull/221/file

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

2020-11-07 Thread frame via Digitalmars-d-learn
On Saturday, 7 November 2020 at 12:29:46 UTC, Andre Pany wrote: Maybe mysql native is slower, but maybe this isn't the case, just the way performance measurements was done was incorrectly. I have tried mysql-native and it tooks way to long for simple things. My test setup is a remote linux vm

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

2020-11-07 Thread frame via Digitalmars-d-learn
On Saturday, 7 November 2020 at 16:37:22 UTC, Vino wrote: , Trying to improve the above code hence request your help on how to use array container instead of array, tried as per the example below but not working. I think you can just use a static array as ubyte[1024] if you want a fixed bu

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

2020-11-07 Thread Vino via Digitalmars-d-learn
On Saturday, 7 November 2020 at 15:26:48 UTC, frame wrote: On Saturday, 7 November 2020 at 14:57:39 UTC, Vino wrote: After further analysis we suspect that the issue is at the package std.net.curl the flow of the program is as below Establishing a new connection may vary in duration of +2

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

2020-11-07 Thread frame via Digitalmars-d-learn
On Saturday, 7 November 2020 at 14:57:39 UTC, Vino wrote: After further analysis we suspect that the issue is at the package std.net.curl the flow of the program is as below Establishing a new connection may vary in duration of +200ms or more.

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

2020-11-07 Thread Vino via Digitalmars-d-learn
: 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: DM

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

2020-11-07 Thread Vino via Digitalmars-d-learn
=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

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

2020-11-07 Thread Vino via Digitalmars-d-learn
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 firs

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

2020-11-07 Thread Andre Pany via Digitalmars-d-learn
On Friday, 6 November 2020 at 04:58:05 UTC, Vino wrote: Hi All, We recently tested the below components and the test results are as below, even though hunt-database is faster than mysql-native it is hard to use this package as it lacks on documentation, non of the example provided in the

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

2020-11-06 Thread frame via Digitalmars-d-learn
On Friday, 6 November 2020 at 04:58:05 UTC, Vino wrote: Component : mysql-native + asdf Executable size : 17 MB Execution time : 10 secs, 189 ms, 919 μs, and 3 hnsecs Component : hunt-database + asdf Executable size : 81 MB Execution time : 5 secs, 916 ms, 418 μs, and 3 hnsecs Interesting

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

2020-11-05 Thread Vino via Digitalmars-d-learn
Hi All, We recently tested the below components and the test results are as below, even though hunt-database is faster than mysql-native it is hard to use this package as it lacks on documentation, non of the example provided in the documentation works, one has to go through the code and

Re: Hunt database

2020-11-03 Thread Andre Pany via Digitalmars-d-learn
/hunt-database, we dont see the prepare method needs SqlConnection as first argument and a string as second where as we can see the need from the source code, so is the example provide in the link is wrong? if yes can you please provide an example nor point me to the correct documentation link

Re: Hunt database

2020-11-03 Thread Vino via Digitalmars-d-learn
On Tuesday, 3 November 2020 at 18:14:33 UTC, Andre Pany wrote: On Tuesday, 3 November 2020 at 14:05:18 UTC, Vino wrote: Hi All, Currently testing Hunt database, and facing an issue as below, hence request your help File : GetConnections.d ### module

Re: Hunt database

2020-11-03 Thread Andre Pany via Digitalmars-d-learn
On Tuesday, 3 November 2020 at 14:05:18 UTC, Vino wrote: Hi All, Currently testing Hunt database, and facing an issue as below, hence request your help File : GetConnections.d ### module common.GetConnections; import hunt.database; class Connections { public Database

Re: Hunt database

2020-11-03 Thread Imperatorn via Digitalmars-d-learn
On Tuesday, 3 November 2020 at 14:05:18 UTC, Vino wrote: Hi All, Currently testing Hunt database, and facing an issue as below, hence request your help [...] What datatype is Seq in your settings table?

Re: Hunt database

2020-11-03 Thread Vino via Digitalmars-d-learn
On Tuesday, 3 November 2020 at 14:47:01 UTC, Imperatorn wrote: On Tuesday, 3 November 2020 at 14:05:18 UTC, Vino wrote: Hi All, Currently testing Hunt database, and facing an issue as below, hence request your help [...] What datatype is Seq in your settings table? Hi, The filed Seq

Hunt database

2020-11-03 Thread Vino via Digitalmars-d-learn
Hi All, Currently testing Hunt database, and facing an issue as below, hence request your help File : GetConnections.d ### module common.GetConnections; import hunt.database; class Connections { public Database conn; this() { conn = new Database("