FilesExpand file tree

develop

/

AppenderBenchmark.cs

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

67 lines (57 loc) · 1.64 KB

develop

/

AppenderBenchmark.cs

Copy path

Top

File metadata and controls

• Code
• Blame

67 lines (57 loc) · 1.64 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

using BenchmarkDotNet.Attributes;

using DuckDB.NET.Data;

namespace DuckDB.NET.Benchmarks;

[MemoryDiagnoser]

public class AppenderBenchmark

{

private DuckDBConnection connection = null!;

[Params(1_000_000)]

public int RowCount { get; set; }

[GlobalSetup]

public void Setup()

{

connection = new DuckDBConnection("DataSource=:memory:");

connection.Open();

}

[GlobalCleanup]

public void Cleanup()

{

connection.Dispose();

}

[IterationSetup]

public void IterationSetup()

{

using var command = connection.CreateCommand();

command.CommandText = "DROP TABLE IF EXISTS bench; CREATE TABLE bench (a INTEGER, b BIGINT, c DOUBLE, d BOOLEAN);";

command.ExecuteNonQuery();

}

[Benchmark(Baseline = true)]

public void AppendRowsWithCreateRow()

{

using var appender = connection.CreateAppender("bench");

for (var i = 0; i < RowCount; i++)

{

appender.CreateRow()

.AppendValue(i)

.AppendValue((long)i)

.AppendValue((double)i)

.AppendValue(i % 2 == 0)

.EndRow();

}

}

[Benchmark]

public void AppendRowsWithAppendRow()

{

using var appender = connection.CreateAppender("bench");

for (var i = 0; i < RowCount; i++)

{

appender.AppendRow(i, static (row, value) =>

{

row.AppendValue(value)

.AppendValue((long)value)

.AppendValue((double)value)

.AppendValue(value % 2 == 0);

});

}

}

}